MYSQL and UNIX timestamps...

MYSQL and UNIX timestamps...

El Forum
Unregistered

#15

04-09-2010, 06:38 AM

[eluser]evolutionxbox[/eluser]
I have put the value '1270159200' which is 2010-04-02 12:00AM (YYYY:MM Big Grin

D HH:MM).
Using the from_unixtime() it returns 2010-04-01 11:00AM.

As far as I know that is -1 hour. I am currently on BST not GMT/UTC. Would that make a difference?

Messages In This Thread

MYSQL and UNIX timestamps... - by El Forum - 04-07-2010, 06:53 PM

MYSQL and UNIX timestamps... - by El Forum - 04-07-2010, 11:32 PM

MYSQL and UNIX timestamps... - by El Forum - 04-08-2010, 12:20 AM

MYSQL and UNIX timestamps... - by El Forum - 04-08-2010, 07:31 AM

MYSQL and UNIX timestamps... - by El Forum - 04-08-2010, 07:38 AM

MYSQL and UNIX timestamps... - by El Forum - 04-08-2010, 08:58 AM

MYSQL and UNIX timestamps... - by El Forum - 04-08-2010, 09:04 AM

MYSQL and UNIX timestamps... - by El Forum - 04-08-2010, 10:15 AM

MYSQL and UNIX timestamps... - by El Forum - 04-08-2010, 05:19 PM

MYSQL and UNIX timestamps... - by El Forum - 04-09-2010, 12:48 AM

MYSQL and UNIX timestamps... - by El Forum - 04-09-2010, 05:45 AM

MYSQL and UNIX timestamps... - by El Forum - 04-09-2010, 05:56 AM

MYSQL and UNIX timestamps... - by El Forum - 04-09-2010, 06:01 AM

MYSQL and UNIX timestamps... - by El Forum - 04-09-2010, 06:15 AM

MYSQL and UNIX timestamps... - by El Forum - 04-09-2010, 06:38 AM

MYSQL and UNIX timestamps... - by El Forum - 04-09-2010, 06:43 AM

MYSQL and UNIX timestamps... - by El Forum - 04-09-2010, 06:56 AM

MYSQL and UNIX timestamps... - by El Forum - 04-09-2010, 07:00 AM

MYSQL and UNIX timestamps... - by El Forum - 04-09-2010, 07:11 AM

MYSQL and UNIX timestamps... - by El Forum - 04-09-2010, 06:14 PM

MYSQL and UNIX timestamps... - by El Forum - 04-12-2010, 12:38 AM