Please start any new threads on our new site at 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 

Starting Member

8 Posts

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

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-'

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

Thank you..


In (Som, Ni, Yak)

17689 Posts

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

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

Go to Top of Page

- Advertisement -