Postgres Pro
Downloads
Home   >   mailing lists

Re: above the date functionssssssss - Mailing list pgsql-sql

From A. Kretschmer
Subject Re: above the date functionssssssss
Date
Msg-id 20060711120207.GF26967@webserv.wug-glas.de
Whole thread Raw
In response to above the date functionssssssss  ("Penchalaiah P." <penchalaiahp@infics.com>)
List pgsql-sql
Tree view 
am  11.07.2006, um 17:04:06 +0530 mailte Penchalaiah P. folgendes:
> 
> Hi good evening to every one.........
> 
> 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...

Simple, to_char is your friend:

test=*# select to_char(current_date, 'MM-YYYY');to_char
---------07-2006
(1 row)


HTH, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    ===

pgsql-sql by date:

Previous
From: "Penchalaiah P."
Date:
Subject: above the date functionssssssss
Next
From: Stuart
Date:
Subject: Re: above the date functionssssssss