Version: 1.0
Type: Function
Category: Calendars/Dates
License: GNU General Public License
Description: Two basic functions to convert a mySQL date to a UNIX timestamp and back.
//date_to timestamp accepts a date as parameter. In mySQLformat: yyyy-mm-dd (eg. 2001-03-16)
//edit the delimiter to your convenience.
//returns $timestamp; the timestamp associated with the input.
function date_to_timestamp ($date)
{
$split_date = split ('-', $date);
$timestamp = gmmktime (0, 0, 0, $split_date[1], $split_date[2], $split_date[0]);
return $timestamp;
}
//timestamp_to_date accepts a timestamp as parameter.
//returns $date. In mySQLformat; yyyy-mm-dd (eg. 2001-03-16)
function timestamp_to_date ($timestamp)
{
$date = date ("Y-m-d" , $timestamp);
return $date;
}