Results 1 to 2 of 2

Thread: Date problem

  1. #1
    Join Date
    Mar 2003
    Memphis, TN, USA

    Post Unanswered: Date problem

    Hi there !
    Can anyone tell me how to convert 1900-01-01 00:00:00 into current date and current time. ?

    I am just one the beginer of MSSQL and ASP. I have a table name annouce which work fine before i altered it. I added one new field named tdate whcih has datetype smalldatetime & have default value getdate().

    When not provide the any value when inserting a new row, I got the error "Column name or number of supplied values does not match table definition. " which is true because the number of supplied value is 1 less then number of column. But then what does the default value meant for ?

    When i provide NULL means( " ") then it automatically add the above mention date and time. ?

    Can anyone put some light why it happend ? Shall, i have to put all the fields name except the new added field ? or i have to do something else.

    With Thanks

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    when you got that error message, it was most likely because you did not specify a column list for the INSERT statement

    let's say your table has five fields, and you add a sixth one

    in order for the default getdate() value to work, you have to say
      into annouce
         ( fld1, fld2, fld3, fld4, fld5 )
         ( 1, 2, 3, 4, 5 )
    this way the number of supplied values equals the number of columns you are inserting into

    the column you did not mention in the insert statement is then given its default value


Posting Permissions

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