|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 9th, 2003, 01:09 AM
|
||||
|
||||
cant sovle insert error
i have a text bow which gets the date in the dd/mm/yyyy forma but when i try to insert it into the datase
i get this error Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E07) [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
|
|
#2
September 9th, 2003, 07:03 AM
|
|||
|
|||
|
Well the error is pretty straightforward no???
The conversion of a char data type to a datetime... Anyway...this means that *you* are trying to insert a datetime value into a *char* type. Make sure the "field you are trying to insert the data into" is a date/time field or vice versa! Hope this helps! Sincerely Vlince
|
|
#3
September 9th, 2003, 07:55 PM
|
||||
|
||||
 well the thing is in my database the value is date/time and initially it was mm/dd/yyyy and everything is fine... for example when i insert 09/09/2003 or 09/29/2003 no errors occur but when i do this 29/09/2003 that error appears :s
|
|
#4
September 9th, 2003, 08:13 PM
|
|||
|
|||
|
Your database server doesn't understand the dd/mm/yyyy type date. Usually a database server is set to a particular locale and interprets dates according to the locale setting.
|
|
#5
September 9th, 2003, 08:54 PM
|
||||
|
||||
|
hey thanks guys... problem solved the probelm it turned out that the local server settings were set to yyyyy/mm/dd lol =)
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > cant sovle insert error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
