in reply to Feedback - Dates From Data to Database

The mysql functions UNIX_TIMESTAMP and FROM_UNIXTIME allow one to convert from the Mysql Date and Time formats to epoch seconds, and back again.

Update as ar0n points out below (that's what you get for going OTTOMH). FROM_UNIXTIME is still correct, however.


Dr. Michael K. Neylon - mneylon-pm@masemware.com || "You've left the lens cap of your mind on again, Pinky" - The Brain
  • Comment on Re: Feedback - Dates From Data to Database

Replies are listed 'Best First'.
(ar0n: unix_timestamp) Re (2): Feedback - Dates From Data to Database
by ar0n (Priest) on Jul 12, 2001 at 21:09 UTC
    UNIX_TIMESTAMP, not UNIXTIME.

    ar0n ]