Help on Oracle date format
From: Tony Cristiano <tiger_at_supa.supacom.brisnet.org.au>
Date: Wed, 13 Apr 94 21:34:54 EST
Message-ID: <gate.2sBRkc1w164w_at_supa.supacom.brisnet.org.au>
Date: Wed, 13 Apr 94 21:34:54 EST
Message-ID: <gate.2sBRkc1w164w_at_supa.supacom.brisnet.org.au>
>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?
>
>any help is appreciated,
>thanks,
>Gihan
If you are using SQL*Plus you can insert a date value into a row column by using the "TO_CHAR" function as follows:
column = to_date(to_char(value,'DD/MM/YYYY'),'DD/MM/YYYY'))
See how you go
Cheers, Tiger Received on Thu Apr 14 1994 - 04:34:54 CEST