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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 convert char to datetime

Author  Topic 

awadi20
Starting Member

10 Posts

Posted - 2009-04-27 : 07:04:52
dear all
I use asp.net 2. I have the following
Dim d_date As date
d_date = FormatDateTime(Now, DateFormat.ShortDate)
when I insert d_date to a table with a field datetime. this error message appear
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value

how can i solve it

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-04-27 : 07:11:38
Duplicate post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=124606



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -