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.
