Postgres Pro
Downloads
Home   >   mailing lists

Re: know the day from timestamp.. - Mailing list pgsql-general

From Stephan Szabo
Subject Re: know the day from timestamp..
Date
Msg-id 20020912064726.Y45340-100000@megazone23.bigpanda.com
Whole thread Raw
In response to know the day from timestamp..  (jerome <jerome@gmanmi.tv>)
List pgsql-general
Tree view 
On Thu, 12 Sep 2002, jerome wrote:

> is there a function that will say the day (monday... sunday) in numeric...
>
> input -- 2002-09-12 20:44:21+08 or just date -- 2002-09-12
>
> will output thursday or 4 just like the date command for the shell..

I believe EXTRACT(DOW from <timestamp>)
will give you a numeric day of week.

pgsql-general by date:

Previous
From: Francisco J Reyes
Date:
Subject: Re: pg_dumpall between Linux and FreeBSD.
Next
From: "Peter Alberer"
Date:
Subject: Postgres hardware configuration, clustering and replication