Re: weekday from timestamp? - Mailing list pgsql-general

From Dann Corbit
Subject Re: weekday from timestamp?
Date
Msg-id D425483C2C5C9F49B5B7A41F89441547010010E3@postal.corporate.connx.com
Whole thread Raw
In response to weekday from timestamp?  ("..::rDk::.." <r.panczak@gmail.com>)
List pgsql-general
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of ..::rDk::..
> Sent: Sunday, September 07, 2008 8:08 PM
> To: pgsql-general@postgresql.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


pgsql-general by date:

Previous
From: Gordon
Date:
Subject: Getting rows in a very specific order
Next
From: Tomasz Ostrowski
Date:
Subject: Re: Autocommit, isolation level, and vacuum behavior