Postgres Pro
Downloads
Home   >   mailing lists

Thread: weekday from timestamp?

weekday from timestamp?

From
"..::rDk::.."
Date:
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?

any help will be much appreciated
cheers
r

Re: weekday from timestamp?

From
"Dann Corbit"
Date:
> -----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

Re: weekday from timestamp?

From
Artacus
Date:
..::rDk::.. wrote:
> 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

Use to_char

to_char(tscol, 'dy')  -> mon
to_char(tscol, 'Day') -> Monday
to_char(tscol, 'D')   -> 2