How to change date format yyyy/mm/dd to dd/mm/yyyy

[smitha mano]

In my PostgreSQL TestDate is the datatype is date.

this field stored in the date format is 2005-11-20.

the date change to 20-11-2005.

I tried many way. but i can't do it

please help me table stored date yyyy/mm/dd is 2005-11-20

i needed to convert this format means dd/mm/yyyy 20-11-2005