Results 1 to 3 of 3

Thread: NULL value for a date field

  1. 09-23-2002, 10:05 AM #1
    SQL23
    SQL23 is offline Registered User
    Join Date
    Sep 2002
    Posts
    1

    NULL value for a date field

    What is the NULL value used for updating or inserting into a date field in SQL. The database is ACCESS 2000.
    Reply With Quote Reply With Quote
  2. 10-22-2002, 03:24 PM #2
    sclark
    sclark is offline Registered User
    Join Date
    Aug 2002
    Posts
    21
    First, you need to make sure that the field in the database accepts null values...you can set this in Table/Design mode. Also make sure that the field is set to Allow Zero Length. Then just enter '' for the value.
    Reply With Quote Reply With Quote
  3. 10-22-2002, 03:29 PM #3
    sclark
    sclark is offline Registered User
    Join Date
    Aug 2002
    Posts
    21
    You can also use something like this:

    RS("field_name") = null
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules