weekday from timestamp?

From: "(dot)(dot)::rDk::(dot)(dot)" <r(dot)panczak(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: weekday from timestamp?
Date: 2008-09-08 03:08:25
Message-ID: d4b6723c-ce3b-4d2e-92c9-71917b182f74@m44g2000hsc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Cai 2008-09-08 03:51:32 Very weird problem of "order by" in postgresql
Previous Message Randal T. Rioux 2008-09-08 02:49:45 Re: 64-bit Compile Failure on Solaris 10 with OpenSSL