Re: SQL Date Challenge

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL Date Challenge
Date: 2001-06-04 18:03:11
Message-ID: m3wv6s3yxs.fsf@dep1.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Josh Berkus" <josh(at)agliodbs(dot)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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message george young 2001-06-04 18:44:18 Re: SQL Date Challenge
Previous Message Josh Berkus 2001-06-04 18:02:32 Re: PGAccess/pgplsql Blues