date in strange format

[cindylens]

Hi
I have date shown in mysql database with this format.

1012858238
1012858364
1012858424
1012863063
1013033139

Is this the format it should be like in mysql? How can I make them readable?

Thanks,
Cindy

[Anon]

I am guessing your date field is either using mysql time or you are storing the return of time() either way its the Unix Epox time, basically every second since Jan 1st 1970 12:00:00am, to get a value for display run it through date() and format as needed

1012858238
Mon Feb 04 14:30:38 2002

[Anon]

Hm. They look like Unix timestamps. The number of second that have elapsed since the beginning of 1970. You're in luck :-)

Check out the date() function www.php.net/date - the timestamps you have in the database are exactly the sort of thing it takes, applying whatever formatting you specify.