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

I tried duplicating this with some strange results when details.time_depart (publication.p_time is my example) is a TIME field. The value is actually stored as the number of elapsed seconds in the day (TIME is a carryover from earlier Forms versions). However, the following (which is identical to your original except for column names) works perfectly when TIME is replaced with DATETIME

:publication.pub_date :=

     to_date(
          to_char(:publication.p_date, 'DD-MON-YY' ) ||   
            to_char(:publication.p_time, 'HH:MIam'), 
               'DD-MON-YYHH:MIam');

Hope this helps!   Received on Tue Feb 18 1997 - 00:00:00 CET