Selecting weekdays from datetime

From: Martin Christensen <factotum(at)mail1(dot)stofanet(dot)dk>
To: pgsql-novice(at)postgresql(dot)org
Subject: Selecting weekdays from datetime
Date: 2000-10-10 14:00:14
Message-ID: 87k8bgx0cx.fsf@fangorn.inspocknito
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Howdy,

I have a database of mailing list entries where I would like to do
some statistics on activity on different days of the week. So say I
want to do something along the hypothetical lines of

SELECT COUNT(*) FROM table WHERE day_of_week(date) = 'Mon'

how do I go about doing that?

Martin

--
GPG public key: http://home1.stofanet.dk/factotum/gpgkey.txt

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bill Morrow 2000-10-10 14:54:10 Re: Selecting weekdays from datetime
Previous Message Gerhard Kroder 2000-10-10 08:28:40 Hello to pgsql!