Home Forums SQL Server 7,2000 T-SQL Do not display "1900-01-01 00:00:00.000" RE: Do not display "1900-01-01 00:00:00.000"

  • August 1, 2011 at 12:47 pm

    #1361779

    UPDATE <table>

    SET <column name> = NULL

    WHERE <column name> = '1900-01-01'

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass