Hi,
For our project we needed to capture the daily hours for employees in HH:MM format.
In order to implement it Numeric(5,2) was used and then it was converted to HH:MM format with control procedure and subroutine.
It will be really helpful if we can have a domain which will allow to store the data as time (without AM/PM).
Thanks,
Rucha