The following syntax is no longer applicable in the where clause.
where [not] time_period1 overlaps time_period2
The following example in the where clause reference pages is also no longer applicable:
Example 9 Compares two time periods and determines whether they overlap each other. The first period begins March 16, 1994 and lasts for one month. The second period begins March 31, 1994 and lasts until December 31, 1994. The predicate returns a value of TRUE because the two periods have points in common:
where (date "1994-03-16", interval +"1" month) overlaps (date "1994-03-31", date "1994-12-31")
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
