default date value in SQL Server

[adrian_quah]

How do i change the default date value of MS SQL's datetime to a value of null? Now, it displays Jan 1 1900 12:00AMeach time?

Thanks!

[Lars_Berg]

Jan 1 1900 12:00AM is what you get if you try to insert an invalid date value.

You could translate it to null

nullif(dc,'Jan 1 1900 12:00AM')

but I would rather fix the insert.

[adrian_quah]

Thanks Lars Berg,

what i did was to compare the date returned...if it was 'Jan 1 1900 12:00AM', i'd have PHP display it as nothing..but if u were to query the db from SQL server's enterprise manager, u'd still see the 'Jan 1 1900 12:00AM'..

works so far 😃

[Sxooter]

Originally posted by adrian_quah
Thanks Lars Berg,

what i did was to compare the date returned...if it was 'Jan 1 1900 12:00AM', i'd have PHP display it as nothing..but if u were to query the db from SQL server's enterprise manager, u'd still see the 'Jan 1 1900 12:00AM'..

works so far 😃

First, you should be able to change the default with some kind of "alter table alter column x set default NULL" or something similar.

Then you can throw an update at the table:

update table x set date = NULL where date='an 1 1900 12:00AM';

And you won't have to do in PHP what your database should be doing.