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 === ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
