Re: above the date functionssssssss

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Penchalaiah P(dot)" <penchalaiahp(at)infics(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: above the date functionssssssss
Date: 2006-07-11 12:10:21
Message-ID: 20060711121021.GA19636@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Jul 11, 2006 at 05:04:06PM +0530, Penchalaiah P. wrote:
> i want to get month and year in the current date..
> see this is date 2005-02-12... here date is 12 , month is 02 and year is
> 2005..
> but i want format like 02-2005...

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

http://www.postgresql.org/docs/8.1/interactive/functions-formatting.html
http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html

--
Michael Fuhr

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Anthony Chavez 2006-07-11 12:56:31 Re: ON INSERT view rule
Previous Message Stuart 2006-07-11 12:02:24 Re: above the date functionssssssss