Re: Find all the dates in the calendar week?

From: Stephane Bortzmeyer <bortzmeyer(at)pasteur(dot)fr>
To: "Andrew Snow" <als(at)fl(dot)net(dot)au>
Cc: "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:20:54
Message-ID: 200007060820.KAA00993@ezili.sis.pasteur.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 6 July 2000, at 18 h 5, the keyboard of "Andrew Snow"
<als(at)fl(dot)net(dot)au> wrote:

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

Sorry, I should have mentioned that I played with to_char and it seems the documentation is wrong:

conferences=> select * from conferences where to_char(CURRENT_TIMESTAMP, 'ww') =
conferences-> to_char(date_begin, 'ww');
ERROR: No such function 'to_char' with the specified attributes

Or it is a new feature of PostgreSQL 7?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Snow 2000-07-06 08:22:48 RE: Find all the dates in the calendar week?
Previous Message Mike Mascari 2000-07-06 08:18:30 Re: Two questions in a row