TO_DATE-Problem
From: (wrong string) üller <holger.heckelmueller_at_bauing.uni-weimar.de>
Date: Wed, 17 Jan 2001 13:23:02 +0100
Message-ID: <9442if$3gi$1_at_linux1.netconx.de>
Date: Wed, 17 Jan 2001 13:23:02 +0100
Message-ID: <9442if$3gi$1_at_linux1.netconx.de>
[Quoted] Hi all,
[Quoted] I would like to reformat a date string like: 'Wed Jan 17 18:50:45 GMT+02:00 2000'.
[Quoted] 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 - 13:23:02 CET