BETWEEN

The BETWEEN operator determines if a given field-expression belongs to a specified interval.

Examples

A. BETWEEN

The following example expression determines if the "Year" field belongs to the specified interval:

Year BETWEEN 1999 AND 2004

This example is equivalent to the following expression:

Year >= 1999 AND Year <= 2004

B. NOT BETWEEN

The following example expression determines if the "Year" field does not belong to the specified interval:

Year NOT BETWEEN 1999 AND 2004

This example is equivalent to the following expression:

Year < 1999 OR Year > 2004

C. TIMESTAMP interval

The following example query uses the FS Input Format to return all the files that have been created between 4 hours ago and 1 hour ago:

SELECT Path 
FROM C:\MyDir\*.* 
WHERE TO_UTCTIME(CreationTime) BETWEEN SUB(SYSTEM_TIMESTAMP(), TIMESTAMP('4', 'h')) AND SUB(SYSTEM_TIMESTAMP(), TIMESTAMP('1', 'h'))

See also:

© 2004 Microsoft Corporation. All rights reserved.

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at webmaster@systemmanager.forsenergy.ru to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.