Re: EASY QUESTION!!

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: dvsangel(at)dodo(dot)com(dot)au (dvsangel), pgsql-sql(at)postgresql(dot)org
Subject: Re: EASY QUESTION!!
Date: 2003-04-30 20:41:35
Message-ID: 200304301341.35146.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

DVS,

> a column in one of my tables contains dates in the format yyyy-mm-dd
> From these dates I need to find out which dates are sundays.
> can anyone help me????
> PLEASE???

SELECT extract(dow from <date field>)

I believe that 0 is sunday.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Achilleus Mantzios 2003-04-30 20:57:31 7.3 analyze & vacuum analyze problem
Previous Message Josh Berkus 2003-04-30 18:48:18 Re: [SQL] 7.3 analyze & vacuum analyze problem