Postgres Pro
Downloads
Home   >   mailing lists

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

From Artacus
Subject Re: weekday from timestamp?
Date
Msg-id 48CB7E8C.7010404@comcast.net
Whole thread Raw
In response to weekday from timestamp?  ("..::rDk::.." <r.panczak@gmail.com>)
List pgsql-general
Tree view 
..::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

pgsql-general by date:

Previous
From: Artacus
Date:
Subject: Re: Getting rows in a very specific order
Next
From: 0123 zyxw
Date:
Subject: Re: Oracle and Postgresql