Re: TO_DATE-Problem
From: RW <rwaszko_at_wcy.wat.waw.pl>
Date: Thu, 18 Jan 2001 16:56:02 +0100
Message-ID: <3A671212.D852A9FF_at_wcy.wat.waw.pl>
Date: Thu, 18 Jan 2001 16:56:02 +0100
Message-ID: <3A671212.D852A9FF_at_wcy.wat.waw.pl>
"Holger Heckelmüller" wrote:
> Hi all,
>
> I would like to reformat a date string like: 'Wed Jan 17 18:50:45 GMT+02:00
> 2000'.
>
> Does anybody knows how it works?
>
> I have tried the following: to_date(a.stringvalue, 'DY MON DD HH24:MI:SS
> YYYY').
>
> I think the problen is: GMT+02:00. Exist a solution for this?
>
> Thanks
>
> Holger
Try this:
to_date(REPLACE(a.stringvalue, 'GMT+02:00 ', '') , 'DY MON DD HH24:MI:SS YYYY')
Good luck
Robert
Received on Thu Jan 18 2001 - 16:56:02 CET