Results 1 to 2 of 2

Thread: insert into

  1. #1
    Join Date
    Dec 2003
    Posts
    3

    Unhappy Unanswered: insert into

    I have a table with dates which is of type "datetime", but entering in SQL code such as :

    INSERT INTO test (code, date)
    VALUES (34, '08/08/03')

    produces an error allong the lines of: You cannot assign a value of type 'integer' to a column of type 'date'. Explicitly convert the value to the required type

    I've tried changing '08/08/03' to 'Aug-08-2003' and '8/8/03' and '08/08/2003' etc etc... does anyone have any ideas why this isn't working??

  2. #2
    Join Date
    Dec 2003
    Posts
    3
    oh don't worry... i'm such a noob was writing to the wrong table and didn't notice...sorry everyone

Posting Permissions

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