[RESOLVED] SQL Date Issue

[Strider]

Im having an issue when inserting a date into my sql server table.

the table's date column is set to smalldatetime

so when i try to insert the date 23/03/2005 into the column, when i look on sql server the field contains 01/01/1900

however if i insert 03/23/2005, when i look on sql server the field contains 23/03/2005

why is this happening..... my regional settings are set to GMT.

[Graff]

There's nothing wrong, thats just the way SQL stores dates.

[Strider]

but why is it requiring me to insert the date in american format.

why cant i insert as the european format

when i insert as european date it gives me an error as it recognises that the 23 is not a month

[szlamany]

but why is it requiring me to insert the date in american format.

why cant i insert as the european format

when i insert as european date it gives me an error as it recognises that the 23 is not a month

SQL Server is very date biased to the American format.

We always use YYYY-MM-DD when doing date INSERT's - so that ambiguity does not become a problem.

[Strider]

to make things all the more strange.......

my application was working fine for the past two weeks then suddenly in the past few days its wont allow me to insert a date.now() into the date field....

i get the error i previously mentioned....


however, however...... when u insert date.today() it sets the date in the field to the 01/01/1900 ...and that aint the right date....

what the hell is going on.

[szlamany]

to make things all the more strange.......

my application was working fine for the past two weeks then suddenly in the past few days its wont allow me to insert a date.now() into the date field....

i get the error i previously mentioned....


however, however...... when u insert date.today() it sets the date in the field to the 01/01/1900 ...and that aint the right date....

what the hell is going on.

01/01/1900 is a "blank" date getting inserted into the date field.