date format in postgresql database

[somaskarthic]

Hi

In postgresql database how to retrieve the date in a required format ? Is ther any method
to retrieve the stored date value in mm/dd/yyyy format. I don't want to set the date format in postgres databse . Whatever format the date value stored , is there any method to retrieve the date in any required format ?
Pls post your replies

Thank n advance
somas

[masdi2t]

Hi

In postgresql database how to retrieve the date in a required format ? Is ther any method
to retrieve the stored date value in mm/dd/yyyy format. I don't want to set the date format in postgres databse . Whatever format the date value stored , is there any method to retrieve the date in any required format ?
Pls post your replies

Thank n advance
somas

please refer to to_char function documentation.
here is a little sample for u:

SELECT to_char(current_date, 'dd/mm/yyyy')