I have an application screen that allows users to enter the hour and minutes a job should be completed by on a 7 day window. For example, JOB ACB must finish by 10:00 AM everyday.

My question is, what datatype do I use in Oracle to store this information? I'm thinking I would use two columns, one to store hours and the other to store minutes. We could store the time in a military format (i.e., 1:00 PM would be stored as 13:00). I would think it would not be a good idea to use the DATE datatype because the date is not needed. Should the two columns be CHAR(2) or NUMBER(2). Any opinions on this one? Thanks.