Re: Tabulate data incrementally - Mailing list pgsql-general

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