Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL Date Challenge - Mailing list pgsql-sql

From Manuel Sugawara
Subject Re: SQL Date Challenge
Date
Msg-id m3wv6s3yxs.fsf@dep1.fciencias.unam.mx
Whole thread Raw
In response to SQL Date Challenge  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: SQL Date Challenge
Re: SQL Date Challenge
List pgsql-sql
Tree view 
"Josh Berkus" <josh@agliodbs.com> writes:

> 
> SELECT ALL Wednesdays BETWEEN 5/1/01 AND 6/1/01;
> 

somthing like:

select date from xx where to_char(date,'fmdy') = 'wed';

hth,
Manuel.

pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: PGAccess/pgplsql Blues
Next
From: george young
Date:
Subject: Re: SQL Date Challenge