Re: Convert a timestamp to RFC822??

Usually you can use a function in your SELECT statement to change the format of your timestamp. In MySQL it's DATE_FORMAT [1]. Otherwise use PHP's Date and Time Functions [2]. You could for instance extract the "ingredients" of your database's timestamp with strptime [3] and reformat it with strftime [4]. Regards, Niels [1] http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html#id2728257 [2] http://php.net/manual/en/ref.datetime.php [3] http://php.net/manual/en/function.strptime.php [4] http://php.net/manual/en/function.strftime.php > 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)...