Thanks, it turns out that the code that was executing the sql was
flawed. Thanks to all that replied!
-Nick
Ian Barwick wrote:
On Thu, 18 Nov 2004 15:01:58 -0600, Nick Peters
<[EMAIL PROTECTED]> wrote:
Hey,
I am trying to compare dates in a sql statement. this is what i have tried:
Hey,
I am trying to compare dates in a sql statement. this is what i have tried:
SELECT * FROM transactions WHERE shippingdate>2004-06-08 AND
transtype='Sale';
but it returns all rows. When i switch the > with a < it returns
nothing. I have even tried with todays date and have got the same
resu
