[thelist] RE: SQL, Dates and more mental health

Ornstein, Ian IanOrnstein at NC.SLR.com
Tue Apr 3 16:58:25 CDT 2001


On SQLServer 6.5 I'd change

SELECT * FROM tblEvents WHERE view_date BETWEEN dteEvStart AND dteEvEnd
to
SELECT * FROM tblEvents WHERE view_date BETWEEN 'dteEvStart' AND 'dteEvEnd'

HTH

Ian Ornstein - Programmer and Web Developer
IBM Global Services, Global AMS Delivery
(704) 509-8022 


-----Original Message-----

SELECT * FROM tblEvents WHERE view_date BETWEEN dteEvStart AND dteEvEnd




More information about the thelist mailing list