I am not sure how to change the date format in PostgreSQL. I have the dates stored in the database as
Expand|Select|Wrap|Line Numbers
- yyyy-mm-dd HH:MM:SS+TimeZone to get the GMT time (Ex: 2008-02-28 14:03:23+05:30)
Expand|Select|Wrap|Line Numbers
- dd/mm/yyyy HH:MM:SS TimeZone (Ex: 28/02/2008 14:03:23 IST)
Expand|Select|Wrap|Line Numbers
- to_char(field_name, 'DD/MM/YYYY HH24:MI:SS TZ') AS field_name
For Ex: When I am trying to sort the output records with the dates then it is not sorting properly.
So can anybody give some idea or example how to do this in other way and get rid of my issue.
Thanks and Regards,
Chittaranjan :)