Date & Hour format in database

[Juan Salvador Peñalver]

Hello! greetings! I got the software and connect to a mysql database, however, I have a question ... format that stores the date and time? although the software is either the date and time a message arrives in the mysql data Abse I get just a series of numbers. For example, a message arrived at 16/11/2011 15:27:54 I get the database in this way: 1321475274000. How do I make the call date and time data from a php progam for viewing on a web page again I convert the date and time in the correct format? Thank you!

[Morgan Belkadi]

Hello Juan,

 

this number you're seeing is called a "timestamp".

It usually represents the time elapsed between the 1st of january 1970 (yes..), and the actual time.

 

I'd suggest you read more on timestamps, and then take a look at the date/time php page, you should find what you're looking for :)

 

Hope that helps.

 

Best,

Morgan