Omar Eljumaily wrote:
I want to tabulate time data on a weekly basis, but my data is entered
on a daily basis.
create table time_data
{
employee varchar(10),
_date date,
job varchar(10),
amount
}
So I want to tabulate with a single sql command. Is that possible?
Try one of these:
=> SELECT date_trunc('week',now());
date_trunc
------------------------
2007-03-05 00:00:00+00
=> SELECT extract(week from now());
date_part
-----------
10
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
