Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003

    Unanswered: store current time in mysql database as time stamp

    what to i set the field type as to record the time time of the entry into my database?

    please help

    thanks in advance

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    setting a column to datatype timestamp records the date/time any changes were made

    if you want to store solely the time a record was inserted then define a DATETIME column and set the value manually. if you are using V5 then you could use a function / stroed procedure to handle this.

    alternatively you could use an audit file recording who did what where and when.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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