More requests about SQL*Forms 3.0 and DATES....
Date: Mon, 01 Jun 1998 18:32:52 GMT
Message-ID: <3572F35F.21F15202_at_bbn.com>
Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
How SQL*Forms 3.0 handles DATE's.
In follow-up to a question I posted late last week can somebody please confirm the following for me:
(1) A date selected into a field of type DATE and length 9 the data will
be DD-MON-YY?
(2) A date selected into a field of type DATE and length 11 the data
will be DD-MON-YYYY?
(3) A date selected into a field of type DATE and length 20 the data
will be DD-MON-YYYY HH:MI:SS?
In each of the above cases assume that the field is populated using the
following statement:
select sysdate
into block.date_field
from dual;
Thanks In Advance
Regards, Martin
PS - I would try the above examples out for myself except that I don't know much about Programming SQL*Forms 3.0. I guess I better learn fast if I am to make them Y2K compliant, huh? :-)
--------------13AE11E9AE3EF4F80BA0D07A Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit
<HTML>
How SQL*Forms 3.0 handles DATE's.
<P>In follow-up to a question I posted late last week can somebody please
confirm the following for me:
<P>(1) A date selected into a field of type DATE and length 9 the data
will be <B><U>DD-MON-YY</U></B>?
<BR>(2) A date selected into a field of type DATE and length 11 the data
will be <B><U>DD-MON-YYYY</U></B>?
<BR>(3) A date selected into a field of type DATE and length 20 the data
will be <B><U>DD-MON-YYYY HH:MI:SS</U></B>?
<P>In each of the above cases assume that the field is populated using
the following statement:
<BR>select sysdate
<BR>into <I>block.date_field</I>
<BR>from dual;
<P>Thanks In Advance
<P>Regards, Martin
<P>PS - I would try the above examples out for myself except that I don't
know much about Programming SQL*Forms 3.0. I guess I better
learn fast if I am to make them Y2K compliant, huh? :-)</HTML>
--------------13AE11E9AE3EF4F80BA0D07A-- Received on Mon Jun 01 1998 - 20:32:52 CEST