Hello all,
I have a table w/ a field of type datetime. I would like to do something like:
select count(jobs) for every day of a particular month and year.
my current select statement is:
Select count(job_id) from jobs where date_part('month',sub_dt)=2 and date_part('year',sub_dt)=1999 and date_
part('day',sub_dt)=?";
I then execute the statement filling the placeholder with days 1..31
There has to be a better way to do this since the select has to go through every row in the table. Any ideas?
thanks,
scot b.