Search Postgresql Archives

Re: weekday from timestamp?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "..::rDk::.." <r.panczak@xxxxxxxxx>
Subject: Re: weekday from timestamp?
From: Artacus <artacus@xxxxxxxxxxx>
Date: Sat, 13 Sep 2008 01:49:16 -0700
Cc: pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <d4b6723c-ce3b-4d2e-92c9-71917b182f74@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
User-agent: Thunderbird 2.0.0.16 (Windows/20080708)

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- weekday from timestamp?
  - From: ..::rDk::..

Prev by Date: Re: Getting rows in a very specific order
Next by Date: Re: Getting rows in a very specific order
Previous by thread: Re: weekday from timestamp?
Next by thread: Very weird problem of "order by" in postgresql
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux