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/

• Next in forum: How to stop PEAR DB reporting errors?
• Prev in forum: Re: correct syntax?
• Thread view: Re: PHP BB Date Column Question

[Reply to this message]