Re: Getting the raw value of a datetime field

Luc Van der Veurst <[email protected]> Thu, 22 Dec 2005 07:03:00 +0100

Newsgroups	gmane.comp.lang.perl.modules.dbi.sybase
Message-ID	<[email protected]>

Hi Alan,

And what if you convert the datetime field to a varchar including the
miliseconds ?

select convert(varchar(30), fieldname, 109)

Luc.

On Wed, 21 Dec 2005 17:41:39 -0800, "Alan Olsen" <[email protected]> wrote:

>Is there a way to get the "raw" value of a datetime field in Sybperl?  I
>have a datetime field that has millisecond values in is, but the display
>is munged to display only down to the minute.
>
>Ideas?
>