dates and 2001

From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Sun, 11 Dec 1994 14:43:00 -0500
Message-ID: <12a.8683.905_at_compudata.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

try " between to_date('06/12/1994','mm/dd/yyyy') and blah blah etc " to ensure that it is truly lookin at the entire year.

---

Internet: barry.roomberg_at_compudata.com (Barry Roomberg)

---

Received on Sun Dec 11 1994 - 20:43:00 CET