time-specification::={SECOND|MILLISECOND|MINUTE|HOUR|DAY}
Specifies a unit of time.
SECOND
Specifies seconds as the unit of time.
MILLISECOND
Specifies milliseconds as the unit of time.
MINUTE
Specifies minutes as the unit of time.
HOUR
Specifies hours as the unit of time.
DAY
Specifies days as the unit of time.
Separately from the time specification, the time value itself is specified as an integer constant. The following table shows the relationship between time specification and integer constants.
Table 4-5 Relationship between time specification and integer constants
No. | Time specification (for specifying a time unit) | Integer constant (for specifying a time value) | ||
---|---|---|---|---|
Operand | Meaning | Minimum value | Maximum value | |
1 | SECOND | Second | 1 | 2678400 |
2 | MILLISECOND | Millisecond | 1 | 86400000 |
3 | MINUTE | Minute | 1 | 44640 |
4 | HOUR | Hour | 1 | 744 |
5 | DAY | Day | 1 | 31 |
Specifies that rows remain in the stream in relation s1 for 2 seconds. The underlined part indicates the time specification.
REGISTER QUERY q1 SELECT * FROM s1[RANGE 2 SECOND];