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

[vssp]

Hai friend please refer this link Its useul for u

http://www.postgresql.org/docs/7.4/interactive/datatype-datetime.html