• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • Last Modified:

Insert null value in date field

What is the syntax to insert null value in date field?
0
peterdevadoss
Asked:
peterdevadoss
1 Solution
 
KarinLoosCommented:

create table #a (somedate datetime)
insert #a values (NULL)
or set domedatefield = NULL


0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now