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

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