RE: Find all the dates in the calendar week?

From: "Andrew Snow" <als(at)fl(dot)net(dot)au>
To: "Pgsql-General(at)Postgresql(dot) Org" <pgsql-general(at)postgresql(dot)org>
Subject: RE: Find all the dates in the calendar week?
Date: 2000-07-06 08:22:48
Message-ID: NHEALMDKDACEIPBNOOOCAEPOCGAA.als@fl.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> SELECT event FROM events WHERE to_char(CURRENT_TIMESTAMP, 'ww') =
> to_char(eventdate, 'ww');

Actually, you will probably want to add something in to make sure the year
is the one you want, too!

- Andrew

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-07-06 08:22:53 Re: PostgreSQL & the BSD License
Previous Message Stephane Bortzmeyer 2000-07-06 08:20:54 Re: Find all the dates in the calendar week?