Re: Problem with Forms5.0 and command SELECT INTO

has to do with the fact that there's an implicit conversion (from DATE to VARCHAR2). Then, the internal format DD-MON-YY is always used (not DD-MMM-YY?). Implicit or explicit, it's better (Y2K bug!) to code this like

select to_char(dt_update,'YYYY-MM-DD') into ...

Bonne chance!
Frank

"James Clément" wrote:

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)