
Creating expressions 14–19
The interval parameter has this format:
<number> <units>
where <units> is one of:
mil (millisecond)
sec (second)
min (minute)
hou (hour)
day (day)
wee (week)
mon (month)
yea (year)
Examples: Time and interval functions
TIME(“sun aug 18 1997 14:30”)
Returns 1 (true) if it is exactly 2:30 pm and 0 seconds, on Sunday, Aug
18, 1997; otherwise returns 0 (false).
_____________________________
AFTER_TIME(“sun aug 18 1997 14:30”)
Returns 1 the first time the expression is evaluated after 2:30 pm on
Sunday Aug 18, 1997.
_____________________________
BEFORE_TIME(“aug 18 1997”)
Returns 1 (true) the first time the expression is evaluated before
Aug 18, 1997.
Comentarios a estos manuales