MySQL and PHP dates? I need to convert UNIX_TIMESTAMP().?

Girlgamer2

New member
Alright so I have this little form where it inserts something like a status. And I use UNIX_TIMESTAMP() to insert it into a mySQL database.

Then I want to echo out the time the status was posted. Example:

"blahblahblah (posted at time)"

But I only get the UNIX_TIMESTAMP version. I want PHP to convert it into "Fri. Sept. 23rd. at 12:00pm" for example.

1316758070 is the UNIX_TIMESTAMP. Can PHP convert that? Or can I use a different function to insert timestamps into the database?
 
Back
Top