Help on Oracle date format
From: Michael Stowe <Michael.Stowe_at_f573.n115.z1.fidonet.org>
Date: Sun, 10 Apr 94 05:02:02 -0600
Message-ID: <328b8bc5_at_f573.n115.z1.fidonet.org>
Date: Sun, 10 Apr 94 05:02:02 -0600
Message-ID: <328b8bc5_at_f573.n115.z1.fidonet.org>
- Quoting Gihan.N.Wikramanayake_at_Cm.Cf.Ac.Uk to All dated 04-07-94 ***
> How can I insert a date value of the type 'DD/MM/YYYY'. I am using
> version 6 and it suggest me to use the format 'DD-MMM-YYYY' for input. Does
> it mean that I have to convert my data set to do this?
No. The function to use is TO_DATE(value, 'DD/MM/YYYY'); Received on Sun Apr 10 1994 - 13:02:02 CEST