formating mysql datetime

[proctk]

Hi I have a variable $dateTime which is set from a mysql query.  The value will always be datetime as that is how the mysql column is set. I want to change the formating of the variable to return a value like

 

august 19 at 3:30 pm

 

any help or direction is excellent

[wmguk]

http://uk.php.net/manual/en/function.date.php

 

something like

<?php

date("F t at g:i a", $date_time)
?> 

will format to august 19 at 3:30pm

 

it will be something like this, however i cannot test it

[proctk]

it retuns this

 

 

    December 31 pm31 7:33 pm

 

this should be 2007-08-20 00:05:10 unformated

[wmguk]

hmm, ok,

<?php

date("F t - g:i a", $date_time)
?> 

 

is this any better?

[AndyB]

http://ca.php.net/manual/en/function.date.php

 

review example 439 to see exactly how to get 'words' into your dates.

[proctk]

thanks for the help, do I need to reformat the date that is returned from the variable that is set from the myslq table

[dbillings]

You haven't showed us the value of the variable returned from your mysql table. So we can't know.

[proctk]

the example posted on the php website do not work when one of the lets used to express a date or time value is use

 

here is what I have

 

date("F t \a\t\ g:i a", $sentMessages['date_sent']); ?>

 

which returns December 31 a 7:33 pm

 

the value stored in the variable is 2007-08-20 00:05:10

 

thanks for the help

[Hypnos]

date() expects a unix time stamp as an input.

 

If you're using PHP 5+, you can use strtotime to convert it to a unix time stamp. A unix time stamp is basicly the number of seconds since 01-01-1970.

 

date("F t \a\t\ g:i a", strtotime($sentMessages['date_sent'])); ?>

[proctk]

thank you for the help

 

its closer what you posted returns this August 31 a 12:05 am

 

its not the correct result based on the above

[Hypnos]

Your date string wasn't right.

 

t - Number of days in the given month.

 

As in the maximum days of that month.

 

date("F j \a\t\ g:i a", strtotime($sentMessages['date_sent'])); ?>

[proctk]

very close

 

its returning the correct date but still leaving the t out

 

value = August 20 a 12:05 am

 

should be August 20 at 12:05 am

[proctk]

any ideas how to get the 't' to print in the date out put

 

thank you