UTC datetime conversion

The va开发者_运维百科lues that I received from my device are: 090211 = ddmmyy and 062123 = hhmmss in UTC.

But I found that the time is always 8 hours later if compared to the time that I need. It is because the time for Malaysia is +8:00. First I would like to add 8 hour, and finally I would like to store this kind of date format into my MySQL database as "2011-02-09 06:21:23". How would I convert these values?

To convert in PHP to a datetime, you will need the function DateTime::createFromFormat(); This function will return a DateTime. Using this function you can also pass the timezone as a parameter.

Example:

$date = DateTime::createFromFormat( 'dmy Gms', '090211 062123', new DateTimeZone("Europe/Amsterdam") );

You can create a output a following:

echo $date->format('Y-m-d H:i:s');

or UNIX timestamp for the MySQL:

echo $date->format('U');

Hope this helps!

PHP has both localtime and gettimeofday functions, are you by chance using the wrong one (or misinterpreting its results)?