FreeTDS Development Group

[James Cameron <cameron AT fax.sno.cpqcorp.net>]

James,

While you've got the whole date thing in pieces on your workbench, any
idea how I can get a datetime down to the seconds, or whatever precision
it is being stored at?

If I do a

        SELECT modify_stmp FROM table [...]

then I get

        'Feb 20 2001 10:57AM'

I can get the seconds if I adjust my code as follows:

        SELECT  CAST(modify_stmp AS VARCHAR(26)) + ' ' + 
                CAST(DATEPART(SECOND, modify_stmp) AS VARCHAR(2))
        FROM table [...]

but this seems somewhat verbose.  Is there a better way?

-- 
James Cameron