#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Location
    san diego, ca, usa
    Posts
    1
    Rep Power
    0
    I have a table that contains two datetime attributes (as well as some ints and varchars)

    I try to load records with an Insert statement similar to the following:
    Insert into xx values( ..., "02-02-00", CURRENT_TIMESTAMP, ...)

    I've looked at manual and searched for examples to no avail...seems most are geared for retrieving data not inserting.

    The CURRENT_TIMESTAMP works but numerous variations of dates don't. I've tried adding "02-02-00 00:00:00", "0000-02-02", single quotes instead of double, etc. etc.

    am i missing something (err don't answer that <grin>


    TIA,

    Roark:-)
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    20
    Rep Power
    0
    Do you mean to be adding '0000-02-02' or '2000-02-02'? Date wants to be a year-month-day format.

Similar Threads

  1. DATETIME problem
    By mstembri in forum PHP Development
    Replies: 17
    Last Post: December 11th, 2003, 09:10 PM
  2. Converting string to datetime format
    By Pex in forum Database Management
    Replies: 3
    Last Post: August 3rd, 2003, 09:00 AM
  3. Inserting DateTime
    By vtaylor in forum PHP Development
    Replies: 5
    Last Post: June 18th, 2003, 10:56 AM
  4. Inserting date into datetime field?
    By Saus in forum PHP Development
    Replies: 2
    Last Post: May 17th, 2003, 08:44 AM
  5. DATETIME vs INT?
    By AlexDG in forum MySQL Help
    Replies: 8
    Last Post: January 30th, 2002, 07:51 PM

IMN logo majestic logo threadwatch logo seochat tools logo