date comparison question

2005-08-01 Thread Kapoor, Nishikant
I am probably missing something very simple, but appreciate it if someone could point me to that. I am doing this query on following table to fetch recs for a month: SELECT fName, lName, acctOpenDate FROM test WHERE acctOpenDate = '2005-07-01' AND acctOpenDate = '2005-07-31'; I expect to see

Re: date comparison question

2005-08-01 Thread SGreen
Kapoor, Nishikant [EMAIL PROTECTED] wrote on 08/01/2005 09:55:21 AM: I am probably missing something very simple, but appreciate it if someone could point me to that. I am doing this query on following table to fetch recs for a month: SELECT fName, lName, acctOpenDate FROM test WHERE