[RESOLVED] RSS Date and Time

[alirezaok]

i am using this code to make Date and Time for RSS:

//some code

$dates=explode('-',$sql->date); //comes from database like as: 2008-01-21
$times=explode(':',$sql->time); //comes from database like as: 02:17:42
$date=strftime( "%a, %d %b %Y %T %Z" , mktime($times[0],$times[1],$times[2],$dates[1],$dates[2],$dates[0]));

//some code for echo othe RSS item

 echo "<pubDate>".$date."</pubDate>\n";  

after running in my host it in RSS reader date and time shoews this for this record:
Monday, January 21, 2008, 5:47:42 AM

date is correct but time is not correct.

also i checked:

$dates=explode('-',"2008-01-21");
$times=explode(':',"02:17:42");

but date is correct and time is not correct for this record. still yet:
Monday, January 21, 2008, 5:47:42 AM

why time is not correct? i want time showes: 02:17:42 AM

i checked it with internet explorer 7 RSS reader.

[alirezaok]

i checked other RSS Reader:
one showes: Sun, 20 Jan 2008 17:47:42 EST
other one showes: Monday, January 21, 2008, 02:17:42 PM

all of them is not corrcet. how set in my php code that any rss reader show time and date correct. i must use of setlocale() or... ? how?

[NogDog]

I would do:

$dateTimeSec = strtotime($sql->date.' '.$sql->time);
// use gmdate() to output UTC time:
$date = gmdate('r', $dateTimeSec); // 'r' = RFC 2822 date format