Page 1 of 1

MySQL timestamp and last modified format

Posted: Wed Jul 23, 2008 2:20 pm
by d_cee
Hi

I'm trying to find out when an entry was first written and then modified by checking the Entries Table timestamp value against the last modified value in phpMyAdmin.

If someone could help interpret 1176735763 as a time/date that would be really helpful as this is the timestamp value and I can't relate it to a date at all :-(

thanks

Dave

Re: MySQL timestamp and last modified format

Posted: Wed Jul 23, 2008 2:32 pm
by garvinhicking
Hi!

Try this: http://www.onlineconversion.com/unix_time.htm

(Mon, 16 Apr 2007 15:02:43 GMT)

Regards,
Garvin

Posted: Mon Aug 04, 2008 12:34 pm
by d_cee
Brilliant!! Just what I need

thanks Garvin

Dave