View Single Post

   
  #4 (permalink)  
Old 02-29-2008, 08:30 PM
--CELKO--
 
Posts: n/a
Default Re: How accurate is GetDate() ?

>> Is T-SQL's GetDate() more accurate than that, or at least non-decreasing? <<

Yes; read the other answers. The real answer is that the FIPS-127
tests require five or more decimal places of seconds in a timestamp for
Federal use. Maybe when we get to 64 bit hardware and a better
internal representation ..

Reply With Quote