Re: weekday from timestamp?

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "(dot)(dot)::rDk::(dot)(dot)" <r(dot)panczak(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: weekday from timestamp?
Date: 2008-09-13 05:47:28
Message-ID: D425483C2C5C9F49B5B7A41F89441547010010E3@postal.corporate.connx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of ..::rDk::..
> Sent: Sunday, September 07, 2008 8:08 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] weekday from timestamp?
>
> im strugling with my dataset..
>
> got a small pgsql db with a timestamp column in format YYYY:MM:DD
> HH:MM:SS for each record
>
> how could i possibly return day of the week for every record?

http://www.postgresql.org/docs/8.0/interactive/functions-datetime.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tomasz Ostrowski 2008-09-13 08:39:54 Re: Autocommit, isolation level, and vacuum behavior
Previous Message Bill Todd 2008-09-12 21:13:00 Re: Windows ODBC Driver