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: > > SELECT * FROM transactions WHERE shippingdate>2004-06-08 AND > transtype='Sale';
SELECT * FROM transactions WHERE shippingdate> '2004-06-08' AND transtype='Sale'; Ian Barwick ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
