Click to See Complete Forum and Search --> : SQL server 01/01/1900


mattastic
02-08-2006, 08:19 AM
Hi,

When I use getdate() as the default value, it keeps inserting 01/01/1900 into the smalldatetime field.

This is weird as it works fine on my other db's.

Can anyone help?

Thankyou