Re: Find all the dates in the calendar week? - Mailing list pgsql-general

From Stephane Bortzmeyer
Subject Re: Find all the dates in the calendar week?
Date
Msg-id 200007060820.KAA00993@ezili.sis.pasteur.fr
Whole thread Raw
In response to RE: Find all the dates in the calendar week?  ("Andrew Snow" <als@fl.net.au>)
List pgsql-general
On Thursday 6 July 2000, at 18 h 5, the keyboard of "Andrew Snow"
<als@fl.net.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?




pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: Two questions in a row
Next
From: "Andrew Snow"
Date:
Subject: RE: Find all the dates in the calendar week?