Getting seconds from a datetime field
Dan Harris
coronadh at coronasolutions.com
Tue Jul 2 11:24:59 EDT 2002
No, it's a datetime type. When I select it, it returns a format of
Jun 1 2002 12:01AM
I would rather have:
2002-06-01 00:01:34
I have tried cast and convert(varchar, colname) but nothing seems to return
seconds.
-Dan
On Monday 01 July 2002 10:19 pm, you wrote:
> Dan,
>
> Are you using smalldatetime? It lacks seconds and milliseconds.
>
> If you're thinking of cast/convert, see
> http://www.SchemaMania.org/jkl/booksonline/SQLBOL70/html/ca-co_1.htm
More information about the FreeTDS
mailing list