Re: [SQL] above the date functionssssssss

2006-07-11 Thread Michael Fuhr
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

Re: [SQL] above the date functionssssssss

2006-07-11 Thread Stuart
2') | "-" | date_trunc('year', DATE '2005-02-12'); Stuart -Original Message- >From: "Penchalaiah P." <[EMAIL PROTECTED]> >Sent: Jul 11, 2006 7:34 AM >To: pgsql-sql@postgresql.org >Subject: [SQL] above the date function

Re: [SQL] above the date functionssssssss

2006-07-11 Thread A. Kretschmer
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_c

[SQL] above the date functionssssssss

2006-07-11 Thread Penchalaiah P.
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... can u tell me how to do this   Thanks  &  Regards Penchal reddy | Software Engineer