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 ===