sybperl-l Archive

From: Luc Van der Veurst <lucv at az dot vub dot ac dot be>
Subject: Re: Getting the raw value of a datetime field
Date: Dec 22 2005 6:03AM

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"  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?
>