[thelist] SQL, Dates and more mental health

Scott Dexter sgd at ti3.com
Tue Apr 3 14:31:39 CDT 2001

I use 

Where (view_date>=dteEvStart and view_date<dteEvEnd)

instead of the between phrase, try that?

work: http://www.ti3.com/
non: http://thinksafely.org/

> -----Original Message-----
> From: Ryan Mayberry [mailto:Ryan at applicor.com]
> SELECT * FROM tblEvents WHERE view_date BETWEEN dteEvStart 
> AND dteEvEnd

More information about the thelist mailing list