datetime

datetime

Post by JK » Sun, 10 Feb 2002 03:59:54



  Hi

 Can you store more then 3 digits of a fraction of second
in SQL Server 2000 datetime field like
1996-07-04 10:15:25.22222 ?

 Is there a style number you can use to convert the same
field value to a string by using the convert command?
  CONVERT ( data_type [ ( length ) ] , expression [ ,
style ] )

 Thanks.

 
 
 

datetime

Post by Andrew J. Kell » Sun, 10 Feb 2002 04:15:19


Quote:>  Can you store more then 3 digits of a fraction of second
> in SQL Server 2000 datetime field like
> 1996-07-04 10:15:25.22222 ?

It's only accurate to 3 milliseconds so that would be useless.  Checkout
BooksOnLine for more info about Datetimes.

Quote:>  Is there a style number you can use to convert the same
> field value to a string by using the convert command?
>   CONVERT ( data_type [ ( length ) ] , expression [ ,  style ] )

All of the STYLES are listed in BooksOnLine under CONVERT.

--
Andrew J. Kelly,  SQL Server MVP
TargitInteractive