Re: know the day from timestamp..

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: jerome <jerome(at)gmanmi(dot)tv>
Cc: PostgresGeneral <pgsql-general(at)postgresql(dot)org>
Subject: Re: know the day from timestamp..
Date: 2002-09-12 13:48:21
Message-ID: 20020912064726.Y45340-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Alberer 2002-09-12 14:14:20 Postgres hardware configuration, clustering and replication
Previous Message Francisco J Reyes 2002-09-12 13:45:26 Re: pg_dumpall between Linux and FreeBSD.