rss xml news feeds (multiple) - standardize Date format

[#1]

I am developing an application and would like to include a simple RSS news reader with various feeds. Works great except the pubDate from each feed is in a different format. How can I standardize? (ex: M/D/YYYY h:mm:ss)

For example in each of these the pubDate is formatted differently

• http://feeds.reuters.com/reuters/technologyNews?format=xml
• http://news.cnet.com/2547-1001_3-0-5.xml

To build the script I use the File Wizard (Web File), specify URL, and then edit to just get what I need. I imagine it is some kind of date formatting...

Ex:

LOAD



 'Reuters Technology News' as Source
,
title


,
description


,
link


,
pubDate
FROM



 [http://feeds.reuters.com/reuters/technologyNews?format=xml] (XmlSimple, Table is [rss/channel/item])
;
CONCATENATE

LOAD


 'CNET News' as Source
,
title


,
description


,
link


,
pubDate
FROM



 [http://news.cnet.com/2547-1001_3-0-5.xml] (XmlSimple, Table is [rss/channel/item])
;

[#2]

You can go to: Edit script/Web files

It will be more sample