sql server and dates

Results 1 to 2 of 2

Thread: sql server and dates

  1. #1
    pJ Guest

    Default sql server and dates

    I&#039;m using sql server 7 <BR>One of the fields is a date field <BR>when i insert a record into that table if the date field is left blank then it records the date as 0111900 - i want it to leave it as null or at least "". any ideas?<BR>thanks

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: sql server and dates

    YOu cant insert "" into a date column cause that is not a valid date.<BR><BR><BR>what you have to do is allow that column to accept Nulls and then insert a Null into that column.<BR><BR>

Posting Permissions

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