Re: Help! SQL example needed for date comparison!
From: Jorge Martinez <jorge_at_image.dk>
Date: 1997/12/12
Message-ID: <01bd073d$4708cb00$0100007f_at_jorge>#1/1
Date: 1997/12/12
Message-ID: <01bd073d$4708cb00$0100007f_at_jorge>#1/1
This also works:
select * from table where trunc(col) = trunc(sysdate-1); Received on Fri Dec 12 1997 - 00:00:00 CET