Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrew Snow
Subject RE: Find all the dates in the calendar week?
Date
Msg-id NHEALMDKDACEIPBNOOOCAEPOCGAA.als@fl.net.au
Whole thread Raw
In response to RE: Find all the dates in the calendar week?  ("Andrew Snow" <als@fl.net.au>)
List pgsql-general
Tree view 
> 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

pgsql-general by date:

Previous
From: Stephane Bortzmeyer
Date:
Subject: Re: Find all the dates in the calendar week?
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL & the BSD License