Re: TO_DATE-Problem
From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Wed, 17 Jan 2001 13:52:55 GMT
Message-ID: <Xsh96.10623$vW4.66440_at_skycache.prestige.net>
Date: Wed, 17 Jan 2001 13:52:55 GMT
Message-ID: <Xsh96.10623$vW4.66440_at_skycache.prestige.net>
select to_date( 'Mon Jan 17 18:50:45 GMT+02:00 2000', 'DY MON DD HH24:MI:SS "GMT+02:00" YYYY') from dual
"Holger Heckelmüller" <holger.heckelmueller_at_bauing.uni-weimar.de> wrote in
message news:9442if$3gi$1_at_linux1.netconx.de...
> 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
>
>
Received on Wed Jan 17 2001 - 14:52:55 CET