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

Janice Powell wrote:
>
> 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

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

If they are, let me know and I'll try to think up something else.

Joe Strano
Dulcian, Inc. Received on Mon Feb 17 1997 - 00:00:00 CET