Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Location
    Montreal, Canada
    Posts
    44

    Unanswered: working with smalldatetime data type

    Hello all,

    if i save a date value within a smalldatetime field, then later want to edit the record and set the smalldatetime field to nothing, how can i do this. I've tried populating the field with Null, and anything else, without success. Any suggestions?

    Sammy

  2. #2
    Join Date
    Feb 2003
    Location
    Auckland, NZ
    Posts
    150
    I just simulated your situation.

    I created a table with a smalldatetime field and then added a date and then set it as null using the following statement

    UPDATE Table1
    SET MyDate = NULL

    If this does not work check if you Allow Nulls on that field
    JJ Kennedy
    Double J IT Solutions
    www.doublejit.co.nz

    VB 6, VB.NET, ASP.NET, MS SQL Server, MySQL, MS Access

  3. #3
    Join Date
    Dec 2002
    Location
    Montreal, Canada
    Posts
    44
    thanks

Posting Permissions

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