Inserting default value for null dates in sql server

Question

I have a table with null-able dates. This has a default constraint of getdate(). If a date is not supplied today's date is inserted. However, I want to convert null's to todays date as well.

Is there a way to force the date to today's date when a null is supplied on an insert.

I do not want to change this to a non-nullable field.

Not sure where the contradiction is so let me clarify - I don't want to change the column to non-nullable but I want to force all inserts with a null date to insert today's date instead. — djnz
– djnz, Commented Nov 4, 2013 at 16:24

Amir Keshavarz · Accepted Answer · 2013-11-04 17:51:42Z

1

try this code:

  Update table
    set Date =Getdate()
    where date=null

answered Nov 4, 2013 at 17:51

Amir Keshavarz

3,1181 gold badge22 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Inserting default value for null dates in sql server

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related