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