[thelist] SQL, Dates and more mental health
Luther, Ron
Ron.Luther at COMPAQ.com
Wed Apr 4 08:50:13 CDT 2001
Hi Ryan,
Yup - working with date/time data can be a pain.
More of a debug than an answer ... but I would try some "where
((Month(Start) > Month(view_date))" and "(Month(End) < Month(view_date))"
alone to see what you get back ... before trying to combine them.
Add the "Year(foo) >= Year(bar)" when you need it as well.
You could also try some "Select view_date, (view_date + 1) as goofy_date;"
to see if it appends that "1" as a text string ... or if it adds a day to
the date as it should. [Ran into something similar to that yesterday
...everything "looked" to be numeric ... but I had to divide a few columns
by "1" to get them recognized as numbers.]
HTH,
RonL.
More information about the thelist
mailing list