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
pgsql-sql by date:
Соглашаюсь с условиями обработки персональных данных