date format

[wimkumpen]

Hello,

I'm reading a rss file, I want to save the items to my database. The pubDate of the rss is something like this:
'Sun, 22 Nov 2009 17:05:47 GMT'.

First of all, how could I convert this string to something like 'yyyy-mm-dd hh:mm:ss' to save to my database.

Secondly, I'm from belgium, my timezone is GMT +1 (and in the summer GMT +2). So, do I need to do something extra with the date?

I'm not so good with date functions...

 

[jpadie]

this should do the necessary

date_default_timezone_set('BELGIUM/BRUSSELS');
$dbDate = date('Y-m-d", strtotime('Sun, 22 Nov 2009 17:05:47 GMT');

 

[wimkumpen]

allright thanks,

Just one thing, it's : 'Europe/Brussels'

 

[jpadie]

it is indeed. or you can use 'CET'.