Postgres Pro
Downloads
Home   >   mailing lists

Re: [Fwd: Day name, month name from a datetime field] - Mailing list pgsql-novice

From Michael Fuhr
Subject Re: [Fwd: Day name, month name from a datetime field]
Date
Msg-id 20050106054248.GA47707@winnie.fuhr.org
Whole thread Raw
In response to [Fwd: Day name, month name from a datetime field]  ("Deepa K" <kdeepa@midascomm.com>)
List pgsql-novice
Tree view 
On Thu, Jan 06, 2005 at 10:07:05AM +0530, Deepa K wrote:
>
> Is it possible to get the rows from table where the day is sunday.
>
> And also is it possible to map the days in all rows to day name and
> similarly is it possible to map the month in all rows to month name.

See the "Data Type Formatting Functions" and "Date/Time Functions
and Operators" sections of the "Functions and Operators" chapter
in the PostgreSQL documentation.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-novice by date:

Previous
From: "Deepa K"
Date:
Subject: [Fwd: Day name, month name from a datetime field]
Next
From: Ronnie Meier Ramos
Date:
Subject: Static variables