Problem with Forms5.0 and command SELECT INTO
From: (wrong string) ément <James.Clement_at_sct.gouv.qc.ca>
Date: Tue, 29 Dec 1998 15:58:45 GMT
Message-ID: <3688FBEE.FC5EA647_at_sct.gouv.qc.ca>
First, excuse my english because i'm a french.
Date: Tue, 29 Dec 1998 15:58:45 GMT
Message-ID: <3688FBEE.FC5EA647_at_sct.gouv.qc.ca>
First, excuse my english because i'm a french.
Explain my problem:
- In forms5, i execute the command SELECT variable_date INTO
variable_char.
- My NLS_DATE_FORMAT from regedit and database is 'YYYY-MM-DD'.
Declare
var_date varchar2(10);
Begin
Select dt_update into var_date from table1;
End;
Question:
Why the result of my request = the format date 'DD-MMM-YY'???
In SQL_PLUS 3.3.4, same request respond correctly? (YYYY-MM-DD)
Thank you
James Clement (email: James.Clement_at_sct.gouv.qc.ca)
Received on Tue Dec 29 1998 - 16:58:45 CET