dates and 2001

From: Frank Greene <74200.427_at_CompuServe.COM>
Date: 9 Dec 1994 17:20:34 GMT
Message-ID: <3ca3l2$54n$1_at_mhadg.production.compuserve.com>


How do you write a BETWEEN retrieval statement that works for dates which span the century mark? I have tried

SELECT the_date_field
FROM the_table
WHERE TO_CHAR(the_date_field, 'mm/dd/yyyy') BETWEEN '06/12/1994' AND '06/12/2003'
;

But it only returns dates up through the end of the current century. Received on Fri Dec 09 1994 - 18:20:34 CET

Original text of this message