Re: [Fwd: Day name, month name from a datetime field]

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Deepa K <kdeepa(at)midascomm(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [Fwd: Day name, month name from a datetime field]
Date: 2005-01-06 05:42:48
Message-ID: 20050106054248.GA47707@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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/

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Randolf Richardson 2005-01-06 07:55:23 Re: postgresql or mysql or oracle?
Previous Message Deepa K 2005-01-06 04:37:05 [Fwd: Day name, month name from a datetime field]