Re: Forms45: problem w/ a time format in a date field
Date: 1997/02/23
Message-ID: <19970223110701.GAA00943_at_ladder02.news.aol.com>#1/1
I'm not sure about this but I seem to remember having a similar problem a
while back, I think it may be that the datatype for the
:details.date_depart field needs to be defined as DATETIME in the form,
rather than just DATE.
Subject: Forms45: problem w/ a time format in a date field From: powell_at_clemson.edu (Janice Powell) Date: 17 Feb 1997 18:05:48 GMT
Message-ID: <5ea6ls$is5_at_hubcap.clemson.edu>
I have 2 items in an application - date_depart_displayed and time_depart,
each having a respective format. When this data is stored to the
database,
it will be stored as a single item -- date_depart. Thus, the 2
application
items need to be concatenated as such:
:details.date_depart :=
to_date(to_char(:details.date_depart_displayed, 'DD-MON-YYYY')||
to_char(:details.time_depart, 'HH:MIAM'),'DD-MON-YYYYHH:MIAM');
My problem, is the time always gets saved as 00:00 and I'm not sure why.
Some debugging statements just before the concatenation, show the
individual
items as how they were entered (eg, 01-FEB-1997 and 09:00AM,
respectively),
but when I query the concatenated item date_depart it is
01-FEB-199700:00AM.
Is a concatenation the wrong thing to do here?
Any help/suggestions will be greatly appreciated. Please send replies to powell_at_clemson.edu.
Thanks.
--JP
Janice Powell
Programmer Analyst
Clemson University
Received on Sun Feb 23 1997 - 00:00:00 CET