RE: Do not display "1900-01-01 00:00:00.000"

SSC Guru

Points: 323506

August 1, 2011 at 12:47 pm

will the column support NULLS? if it can, you could update the data to be null where the column is that value.

it really depends on the table and the columns' datatype .

also, will your application crash if it gets a null value for that field, assuming it's trying to populate a datepicker control or something?

UPDATE YOURTABLE

SET ThatColumn = NULL

WHERE ThatColumn = '1900-01-01 00:00:00.000'

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!