Post reply

Default Date N Times

  • March 7, 2003 at 6:52 am

    #81710

    Good afternoon, I seem to be having a date problem day today.

    Ok here goes, How can I stop SQL Server from putting a date of 01/01/1900 into the date field when no user date is input.

    Thanks.

    Gazzer

  • March 7, 2003 at 7:45 am

    #450530

    If you don't want SQL Server to put anything in the field, then make the field NOT NULL. There is a default set either at the table schema level or an an INSERT procedure that is throwing the default value of 0 to the field, producing '1/1/1900 00:00:00'. Check BOL for more info on default constraints.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply