|
Posted by Joseph Melnick on 06/20/05 18:49
Craig Keightley wrote:
"Craig Keightley" <dont@spam.me> wrote in message
news:42b6ca84$0$292$cc9e4d1f@news-text.dial.pipex.com...
>I have a PHP BB installed and want to run a query to convert the topic_time
>column into a valid date
> the column contains a time stamp (i presume)
> the value 1119265019 should be displayed as Thu Jun 16, 2005 10:19 am
> Any Suggestions?
>
> Craig
>
Hello Craig,
Take a look at the date() function at
http://www.php.net/manual/en/function.date.php.
There you will also find some mysql function examples specific to formatting
datetime and timestamp field results.
Joseph Melnick
JM Web Consultants
http://www.jphp.com/
Navigation:
[Reply to this message]
|