Crazy and Weird Output !!!!!!!!!!!!!!!

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  November 17, 2009 at 4:14 am

  #96478

  hi

  i am getting different output than the inserting values

  --------------------------------------------------------------------------------------

  create table a ( abc datetime)

  insert into a values(cast(('2009-11-16 23:43:57.049') as datetime))

  select * from a

  output

  ---------------------

  2009-11-16 23:43:57.049

  insert into a values('2009-11-16 23:43:57.058')

  select * from a

  output

  ---------------------

  2009-11-16 23:43:57.053

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• Paul White

  SSC Guru

  Points: 150468

  More actions

  November 17, 2009 at 4:25 am

  #1080145

  http://stackoverflow.com/questions/634122/milliseconds-wrong-when-converting-from-xml-to-sql-server-datetime

  Paul White
  All articles available on SQL.kiwi
  @SQL_Kiwi

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  November 17, 2009 at 4:30 am

  #1080148

  thanks

  but any alternative for it ?

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

• Paul White

  SSC Guru

  Points: 150468

  More actions

  November 17, 2009 at 4:35 am

  #1080152

  Not sure what you mean, but SQL Server 2008 has date and time types accurate to 100 nanoseconds.

  Paul White
  All articles available on SQL.kiwi
  @SQL_Kiwi