Next: , Previous: Temporal Types, Up: Temporal Types



3.7.1 Temporal Constants

There is currently no way to specify an absolute time as a constant (though see the current_time and network_time functions in XXX). You can specify interval constants, however, by appending a time unit after a numeric constant. For example,

         3.5 min

denotes 210 seconds. The different time units are usec, sec, min, hr, and day, representing microseconds, seconds, minutes, hours, and days, respectively. The whitespace between the numeric constant and the unit is optional, and the letter “s” may be added to pluralize the unit (this has no semantic effect). So the above example could also be written:

         3.5mins

or

         150 secs