Database format for timestamp?

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
meyersjd
Posts: 2
Joined: Fri Jan 11, 2008 3:01 am

Database format for timestamp?

Post by meyersjd »

What is the format for generating the numbers in the database field for entry time stamps?

For instance what would "1123069245" translate to in real time?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Database format for timestamp?

Post by garvinhicking »

Hi!

Those are called "UNIX Timestamps",you can look up the definition in wikipedia for example. It's the number of seconds that passed by since Januar 1st 1970.

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/
meyersjd
Posts: 2
Joined: Fri Jan 11, 2008 3:01 am

Thanks!

Post by meyersjd »

Number of seconds huh? Wow.
Thanks!
Post Reply