Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Script Library
 fwd : Datetime error in sql server

Author  Topic 

lakshmi04
Starting Member

8 Posts

Posted - 2012-11-08 : 04:14:54
hi..


the conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

This error is coming in Sql when i was trying to get the date which is in the format '1998-12-10-12.18.35.535134'

kindly give me solution how it formats and give correct output.

Thank you..

lakshmi

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2012-11-08 : 04:45:11
should be just
'1998-12-10 12:18:35.535'


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -