NULL date in SQL

Results 1 to 2 of 2

Thread: NULL date in SQL

  1. #1
    Join Date
    Dec 1969

    Default NULL date in SQL

    To all helping me...first, thanks!<BR><BR>I&#039;m actually writing to a bit field and date field (of a much larger table). If my user makes a mistake and would like to delete an entry, I turn the bit field to "0" and replace the date that was originally entered as a NULL. All my attemps have created the 1/1/1900 value. The only way I can get NULL into the field is to CTRL 0 the field in Enterprise Manager.<BR><BR>Bill..I&#039;m not Norman, just happen to be on the same general topic you answered for him earlier in the forum. :)<BR><BR>Kevin

  2. #2
    Join Date
    Dec 1969

    Default RE: NULL date in SQL

    You must use the keyword NULL in your insert/update statement<BR><BR>e.g.<BR><BR>update t set datefield = null where pkC = 4711

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts