Marek at 14:39, 17 July 2012

2012-07-17T14:39:26Z

Marek: Created page with "Match a range of dates

schema:scott

The BETWEEN clause may be used with dates, numbers and strings.

2012-07-17T14:39:05Z

Created page with "Match a range of dates <div class='ht'> <div class=params>schema:scott</div> <div> The BETWEEN clause may be used with dates, numbers and strings. </div> <source lang=sql cla..."

New page
Match a range of dates
<div class='ht'>
<div class=params>schema:scott</div>
<div>
The BETWEEN clause may be used with dates, numbers and strings.
</div>

<source lang=sql class='tidy'></source>
<source lang=sql class='setup'></source>

<source lang='sql' class='def'>
SELECT * FROM totp
WHERE wk BETWEEN DATE '1980-05-20'
AND DATE '1980-05-26'
</source>

<source lang='sql' class='def e-sqlserver e-sqlite e-db2'>
SELECT * FROM totp
WHERE wk BETWEEN '1980-05-20'
AND '1980-05-26'
</source>

<source lang='sql' class='def e-access'>
SELECT * FROM totp
WHERE wk BETWEEN #20 May 1980#
AND #26 May 1980#
</source>

<div class="ecomm e-db2" style="display: none"></div>
</div>
{{DATE and TIME ref}}

@@ Line 1: / Line 1: @@
 Match a range of dates
 <div class='ht'>
-<div class=params>schema:scott</div>
+<div class=params>schema:gisq</div>
 <div>
 The BETWEEN clause may be used with dates, numbers and strings.