tim's journal

Converting dates between MySQL and PHP

Thanks Simon, for the tip. "You can use MySQL's UNIX_TIMESTAMP() and FROM_UNIXTIME() functions to convert Unix timestamps to MySQL date types as part of your SQL queries." For example,

SELECT 
  entries.*, UNIX_TIMESTAMP(added) as unixtime
FROM 
  enries
...

and

INSERT INTO 
  entries
SET  
  title = 'The title', 
  added = FROM_UNIXTIME(1057941242),
...

Yay! No more INT(11) for me.

Posted by torque at August 18, 2004 11:56 AM | TrackBack