MYSQL and UNIX timestamps...

MYSQL and UNIX timestamps...

El Forum
Unregistered

#10

04-09-2010, 12:48 AM

[eluser]mddd[/eluser]
There could be time offset issues. A Unix timestamp has no 'time zone' in it. So it could be that you have to compensate for a shift in time zones. You can try this by saving something to your database at a known time and then looking at the date/time you get back when you use from_unixtime. If there is a difference, you'll have to add/subtract a number of hours.

Unix timestamps are nice for comparing to see how long ago something was (in seconds), but less nice for storing exact dates/times. At least that is my opinion.

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