Forms45: problem w/ a time format in a date field

[Quoted] 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 :=
[Quoted]  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 Mon Feb 17 1997 - 00:00:00 CET