MySQL timestamp and last modified format

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
d_cee
Regular
Posts: 603
Joined: Wed Jan 18, 2006 6:32 pm
Location: UK
Contact:

MySQL timestamp and last modified format

Post 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
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: MySQL timestamp and last modified format

Post by garvinhicking »

Hi!

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

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

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
d_cee
Regular
Posts: 603
Joined: Wed Jan 18, 2006 6:32 pm
Location: UK
Contact:

Post by d_cee »

Brilliant!! Just what I need

thanks Garvin

Dave
Post Reply