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

Joseph Strano wrote:
> > :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.
 

> Check to ensure the datatypes of the two fields in the application are:
> date_depart_displayed - DATE
> time_depart - TIME

According to Forms documentation data type DATE contains a ZERO time component. You may need type DATETIME for :details.date_depart. Received on Tue Feb 18 1997 - 00:00:00 CET