Re: Problem with Forms5.0 and command SELECT INTO
From: Jan Hansen <jan_at_brandsoft.dk>
Date: Fri, 8 Jan 1999 16:12:45 +0100
Message-ID: <Repl2.256$ga1.262_at_news.get2net.dk>
Received on Fri Jan 08 1999 - 16:12:45 CET
Date: Fri, 8 Jan 1999 16:12:45 +0100
Message-ID: <Repl2.256$ga1.262_at_news.get2net.dk>
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
This also makes it impossible to use the copy
command on date-parameters
copy('01-01-2000','parameter.my_parameter');
----won't work because of wrong
format.
copy('01-JAN-00','parameter.my_parameter');
----This works, but it will always default to
01-01-1900
Items will however accept the following
copy-command,
althoug it is not the default
format.
copy('01-01-2000','my_block.my_item');
Is there any way to solve this Y2K problem, when
you have to use 'copy'?
----Jan