Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Forms 4.5 date/datetime items

Forms 4.5 date/datetime items

From: Heiko Herms <Heiko.Herms_at_BITOEK.UNI-BAYREUTH.DE>
Date: Mon, 4 Mar 1996 16:55:47 EST
Message-Id: <9603041611.AA22081@alice.jcc.com>


The following behaivour of date/datetime items in forms 4.5 is a mystery for me:

I have a LOV based of a table with two date items TSTART and TEND. Also a form with two items :TSTART and :TEND. The LOV items are mapped to the form items.

  1. :TSTART and :TEND are defined as DATE and a format mask 'DD.MM.RR HH24:MI'
    => TSTART und TEND will be mapped correctly when using the LOV, this
    means TSTART und TEND will be copied in :START and :TEND. But if I'am using :START or :TEND in a procedure, the format mask will not be applied, e.g. '1.1.94 00:00' in forms is '1.1.0094 00:00' in a procedure.
  2. :TSTART and :TEND are defined as DATETIME and a format mask 'DD.MM.RR HH24:MI'
    => TSTART und TEND will not be mapped when using the LOV, this
    means TSTART und TEND will not be copied in :START and :TEND. When writing some dates in :TSTART and :TEND by hand, the format mask will be applied, e.g. '1.1.94 00:00' in forms is '1.1.1994' in a procedure.

Thanks for any help !

Heiko Received on Mon Mar 04 1996 - 11:11:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US