Another annoying SQL date question...
Date: 1996/06/21
Message-ID: <4qeab2$80o_at_knot.queensu.ca>#1/1
Hello:
Using straight SQL, when given a start date and an end date,
how can one determine whether a Friday or a Monday exists during
the date span.
(note first example starts and stop on same day)
Any information would be greatly appreciated. I will continue to try and
figure this out, and if I get it first I'll post a summary anyway. :-)
--------------< LINUX: The choice of a GNU generation. >---------------
Eg. "960601 - 960601" - no, does not contain a Friday or Monday
Eg. "960601 - 960602" - no, does not contain a Friday or Monday
Eg. "960601 - 960610" - yes, contains a Friday and/or Monday
Steve Frampton http://qlink.queensu.ca/~3srf
Work: <frampton_at_mail.flarc.edu.on.ca> School: <3srf_at_qlink.queensu.ca>
Received on Fri Jun 21 1996 - 00:00:00 CEST