Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone help me figure out how to convert these RSS dates from this text format into actual dates in the script load? I don't care about the time info.
I got it.
timestamp(timestamp#(mid(pubDate,6,20),'DD MMM YYYY hh:mm:ss'),'MM-DD-YYYY hh:mm:ss') as RSS_DateTime
I got it.
timestamp(timestamp#(mid(pubDate,6,20),'DD MMM YYYY hh:mm:ss'),'MM-DD-YYYY hh:mm:ss') as RSS_DateTime
Hi, try
(date#(PurgeChar(left(mid(Datum,5) ,12),' '),'DDMMMYYYY')) as Date
Hi Brian,
just use this expression:
Date(Date#(Mid(pubDate,6,11), 'DD MMM YYYY')) as pubDate, |
- Ralf