Re: Convert a timestamp to RFC822??
| From: | Kevin Waterson | Date: | Sun, 11 Sep 2005 00:30:52 +0000 |
| Subject: | Re: Convert a timestamp to RFC822?? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-222136@lists.php.net to get a copy of this message | ||
This one time, at band camp, Brian Dunning <brian@briandunning.com> wrote:
> I get my timestamp from the db in this format (I don't have control
> over this):
>
> 2004-05-14 13:24:48
>
> I need to convert it to RFC822 to make it a valid RSS pubDate field
> like this:
>
> Wed, 02 Oct 2002 13:00:00 GMT
>
> How can I do that? I'm tearing my hair out here (what's left)...
SELECT *, DATE_FORMAT(yourdatecolumn,'%d, %m,%Y %h:%i %p') AS your_date FROM table
just change the %m options to suit the format you wish.
You will then have a field called your_date that you can access in your loop
like
while($row=mysql_fetch_array($result))
{
echo $row['your_date'];
}
enjoy,
kevin
--
"Democracy is two wolves and a lamb voting on what to have for lunch.
Liberty is a well-armed lamb contesting the vote."