SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Script Library
 fwd : Datetime error in sql server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lakshmi04
Starting Member

India
8 Posts

Posted - 11/08/2012 :  04:14:54  Show Profile  Reply with Quote
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)

Singapore
17595 Posts

Posted - 11/08/2012 :  04:45:11  Show Profile  Reply with Quote
should be just
'1998-12-10 12:18:35.535'


KH
Time is always against us

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000