Inserting Date in Sql Server

lamdog · March 10th, 2005, 12:30 AM

Hi,
   I tried to insert date into the Sql database using parameters but it prompt me this error message:
"Arithmetic overflow error converting expression to data type datetime. The statement has been terminated."
   My date format is in dd/MM/yyyy. Can it be the format in the Sql database that causes this error? Any ideas?
   Thanks.

Regards

jbenson001 · March 10th, 2005, 01:17 AM

Make sure you data type in SQL is date time. Pass the parameter with single quotes. Ex '01/01/2005' Also, make sure the date is valid. For example I have seen the error when trying to insert an incorrect date such as '02/29/2005'

lamdog · March 10th, 2005, 03:55 AM

I have changed the data type for the field and it worked fine now i have to format the datetime to my output of my datagrid without displaying the time...
Thanks for the help...

Regards

mehdi62b · March 10th, 2005, 08:00 AM

also check out this thread.

_____________
Mehdi.
software student.

akash · March 15th, 2005, 10:28 AM

Checkout this format
dd-MM-yyyy

mehdi62b · March 18th, 2005, 01:05 PM

Code:

<asp:BoundColumn DataField=startDate HeaderText="startDate" DataFormatString="{0:dd-MMM-yyyy HH:mm:ss}">
</asp:BoundColumn>

Custom DateTime Format Strings

_____________
Mehdi.
software student.