Quote:
Originally Posted by 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
please refer to
to_char function documentation.
here is a little sample for u:
-
SELECT to_char(current_date, 'dd/mm/yyyy')
-
