Re: day of week

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: day of week
Date: 2007-11-01 10:03:12
Message-ID: fgc890$pjh$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Anton Andreev wrote on 31.10.2007 15:34:
> Hi,
>
> I have records with date column. Is there a way I can get which day of
> week this date is?

What about the extract() function with the dow parameter?

<http://www.postgresql.org/docs/8.2/static/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT>

Thomas

In response to

  • day of week at 2007-10-31 14:34:44 from Anton Andreev

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2007-11-01 10:11:00 Re: day of week
Previous Message Pavel Stehule 2007-11-01 09:52:36 Re: day of week