Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2012
    Posts
    133

    Unanswered: updating datetime column to null value

    ei guys,
    how do you update datetime column to NULL with datetime as datatype. mind if you give sample on command. TIA.

  2. #2
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    update <tablename> set <column_name> = NULL

    Include a where-clause to only update the specific record you need.
    This only works if the column allow NULL values.
    I'm not crazy, I'm an aeroplane!

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    ...assuming of course you have "allowed" NULLs as part of the column definition
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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