how to use sysdate
455054Mar 23 2007 — edited Mar 23 2007I am trying to get the projects let date less than the sysdate. for example today is
march 23,2007 so I want to get the total number of projects let less thant 03/23/2007. thanks for the help.
select count(*) "Total Projects",to_char(b.datelet,'YYYY') "Letting Year"
from bidlet b, letprop l, proposal p
where l.letting= b.letting and l.lcontid = p.contid
and substr(l.lcontid, 4) <'5'
and to_char(b.datelet,'YYYY') = '&year'
group by to_char(b.datelet,'YYYY')