Any PHP or MySQL function to get the Unix time without affecting the Timezone

Question

I have stored a time in my database, for example this data: 2014-03-25 13:15:00

But when I use UNIX_TIMESTAMP(date_field) through mysql query or strtotime() in PHP, both functions output is effected by timezone.

Please tell me if it's possible to get unix time without timezone effect? It will also be very helpful if anyone can provide a PHP function.

Please do not suggest to me to change the timezone, because this is not a suitable solution.

Current output of 2014-03-25 14:05:00 when covert to unix and then again convert to date 2014-03-25 08:35:00

UPDATE

this not only happen only to DB time. like if I directly call this : date('Y-m-d H:i:s', strtotime(2014-03-25 14:05:00))

then it output

2014-03-25 08:35:00

I never set timezone, i think it will be default timezone. (by the way I am using WAMP) — user007
– user007, Commented Mar 25, 2014 at 8:09
@hago I use timestamp data type, but this problem is related to timezone — user007
– user007, Commented Mar 25, 2014 at 8:10
Performing UNIX_TIMESTAMP(timestamp_type_column) will not perform any timezone conversion whatsoever, as TIMESTAMP type columns are already stored in UTC. However, storing literal '2014-03-25 13:15:00' into a TIMESTAMP type column must therefore convert from the session's time_zone to UTC, which is presumably the effect to which your question refers. But how could one expect otherwise? — eggyal
– eggyal, Commented Mar 25, 2014 at 8:21

Ja͢ck · Accepted Answer · 2014-03-25 08:48:23Z

1

With PHP you can use DateTime:

$date = new DateTime('2014-03-25 13:15:00', new DateTimeZone('UTC'));

echo $date->format('Y-m-d H:i:s'); // 2014-03-25 13:15:00
echo $date->format('U'); // 1395753300

This assumes the times in your database are expressed in UTC.

Before PHP 5.3

$date = '2014-03-25 13:15:00';
echo gmdate('Y-m-d H:i:s', strtotime("$date GMT"));

edited Mar 25, 2014 at 8:48

answered Mar 25, 2014 at 8:36

Ja͢ck

174k39 gold badges269 silver badges317 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

eggyal Over a year ago

Of course, this assumes that the literal is in fact in UTC (which I somehow doubt). :)

user007 Over a year ago

Thanks I will try this solution, but most of my users are not uing php5.3 (i know its old) but then I have to ask them to update to 5.3. But indeed I will try this.

Ja͢ck Over a year ago

@user007 I've added pre 5.3 version.

user007 Over a year ago

Your solution output correct date when I use gmdate() but still UNIX time is not correct. I have already time stamp, and I want correct UNIX time. Thanks for your help.

user007 Over a year ago

strtotime('2014-03-25 14:05:00') is outputting 1395756300

|

Collectives™ on Stack Overflow

Any PHP or MySQL function to get the Unix time without affecting the Timezone

1 Answer 1

Before PHP 5.3

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Before PHP 5.3

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related