Hi I am trying to setup a timesheet app. However I have come up against
an unexpected problem (possibly fatal)
I cannot seem to find a field type in postgres that is equivalent to
h:mm without enforcing a 24 hour day limit. This seems to preclude pg
from use - am I correct?
All the date-time
mike wrote:
I cannot seem to find a field type in postgres that is equivalent to
h:mm without enforcing a 24 hour day limit. This seems to preclude pg
from use - am I correct?
You want to use interval data type and then do some formatting on the
output to get 123 hours 30 minutes.
See:
mike wrote:
All the date-time types seem to only be for specific time dates and
not for a running total.
You probably want the interval type.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send