3. QUEL Data Types : Data Types : Date Data Type : Time Interval Formats
 
Share this page                  
Time Interval Formats
You can express time intervals as hours, minutes, seconds, or combinations of these units. (You can abbreviate time intervals to hrs, mins, or secs.) For example:
"23 hours"
"38 minutes"
"53 seconds"
"23 hrs 38 mins 53 secs"
"23 hrs 53 seconds"
"28 hrs 38 mins"
"38 mins 53 secs"
"23:38 hours"
"23:38:53 hours"
All values in an interval must be in the range -2,147,483,639 to +2,147,483,639. The DBMS Server adjusts time units as appropriate, as illustrated in the following table:
Value entered
Value displayed
3601 seconds
1 hrs 1 secs
61 minutes
1 hrs 1 mins
26 hours
1 day 2 hours