Conversion

datetime conversion

Type:	code fragment
Added by:	Peppe316
Entered:	15/04/2001
Last modified:	04/12/2000
Rating:	- (fewer than 3 votes)
Views:	15027

Use this function to convert a mysql datetime field from the YYYY-MM-DD 00:00:00 format to the Seconds since Epoch and vise versa. Returns seconds since epoch and the datetime

<?
 ############

                            # �2001 CodeHeadz.net

                            # Function is released under the GPL and is free as long as

                            # this header remains intact

                            #############
 function datetime_to_epoch($date) {

                              $break = explode(" ", $date);

                              $datebreak = explode("-", $break[0]);

                              $time = explode(":", $break[1]);

                              $epoch = date("U", mktime($time[0],$time[1],$time[2],$datebreak[1],$datebreak[2],$datebreak[0]));

                              $datetime = date("Y-m-d H:i:s", mktime($time[0],$time[1],$time[2],$datebreak[1],$datebreak[2],$datebreak[0]));

                            }
 ?>

Usage Example

See the example

Rate This Script

Zend - The PHP Company

Conversion

Search