Re: weekday from timestamp?

From: Artacus <artacus(at)comcast(dot)net>
To: "(dot)(dot)::rDk::(dot)(dot)" <r(dot)panczak(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: weekday from timestamp?
Date: 2008-09-13 08:49:16
Message-ID: 48CB7E8C.7010404@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

..::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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2008-09-13 11:41:05 Re: Getting rows in a very specific order
Previous Message Artacus 2008-09-13 08:46:43 Re: Getting rows in a very specific order