[SQL] How to insert/select date fields in a particular format

[Ramesh H R]

Hello everyone,
Please help me in knowing how to insert/select date fields in a
particular format in postgres.

Thanks in advance
Ramesh