Dev2K -- Time field question

[Quoted] [Quoted] I have a form containing a date field with the format HH24:MI:SS. I am populating this field with data from another table using the following type of query:
 SELECT TO_DATE(TO_CHAR(hr_field)||':'||TO_CHAR(min_field),'HH24:MI')  INTO field
 FROM table_name;

The problem is that the field is always gettin populated with 00:00:00.

Does anyone have a solution?

-- 
Ashok F. Kapur    | Galaxy Latin America |
Project Engineer  | (954)958-3373        |
afkapur_at_ccgate.hac.com