Re: Help on Oracle date format
From: Jim Egerton Digital-PCS GmbH <egerton_at_pcs.dec.com>
Date: Fri, 8 Apr 1994 07:21:38 GMT
Message-ID: <1994Apr8.072138.9302_at_janix.pcs.dec.com>
Date: Fri, 8 Apr 1994 07:21:38 GMT
Message-ID: <1994Apr8.072138.9302_at_janix.pcs.dec.com>
|>
|>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?
|>
I'm not sure if this is available on V6, but on V7 you can use the TO_DATE operator to convert the date:
INSERT INTO date_table (date_field)
VALUES (TO_DATE('12/11/1961 12:00:00', 'MM/DD/YYYY HH24:MI:SS'));
hope this helps,
jim
Received on Fri Apr 08 1994 - 09:21:38 CEST