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>
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