Output date and time from database

[merylvingien]

Hi Fellas, having a bit of trouble getting the date and time to display correctly from database.

 

At the moment i have the date stored in the database as "datetime" and as an example it stores the date as "2010-01-19 17:01:11"

 

I want to output this on the page as  Tuesday 19 2010 @ 17:01 PM

 

But whatever i try it isnt having it.

 

Ive tried numerous things and googled lots, but i think my brain is fried now, and a little help would good.

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-format

[wildteen88]

Have a read of this article

http://www.phpfreaks.com/tutorial/working-with-dates-in-php

[merylvingien]

Thanks for the links, but they arent helping.

 

I can store the date in the database fine.

I can also get the bloody date back out of the database, but when i want to add a "pm" or "am" is wont have it...

 

This must be done daily, so someone must know.

[wildteen88]

You can use strtotime to convert your mysql timestamp into a unix timestamp. Using the unix timstamp you can pass this into the secound parameter for the date function to reformatted your date. Example

 

$mysqlTimestamp = '2010-01-19 17:01:11';

$unixTimestamp = strtotime($mysqlTimestamp);

echo date('l jS Y h:i:s a', $unixTimestamp);

[merylvingien]

THATS IT 

 

Many thanks wildteen88 You are a star...