Re: Another annoying SQL date question...

From: Frampton Steve R <3srf_at_qlink.queensu.ca>
Date: 1996/06/23
Message-ID: <4qjsbp$e2o_at_knot.queensu.ca>#1/1

Tim Perrault (timp_at_asymetrix.com) wrote:

: SELECT 'Yes'
: FROM DUAL
: WHERE '6' BETWEEN TO_CHAR(TO_DATE('061096','MMDDYY'),'D') AND
: TO_CHAR(TO_DATE('060196','MMDDYY'),'D');
Thanks Tim...although...seeing the solution *does* make me feel really stupid... :-}

--------------< LINUX: The choice of a GNU generation. >---------------

Steve Frampton                          http://qlink.queensu.ca/~3srf

Work: <frampton_at_mail.flarc.edu.on.ca> School: <3srf_at_qlink.queensu.ca> Received on Sun Jun 23 1996 - 00:00:00 CEST