Question: how to convert yyyy-mm-dd to dd-mm-yyyy in postgresql?
Answer: SELECT to_char("date", 'DD/MM/YYYY') FROM mytable; e.g. The output format of the date/time types can be set to one of the four styles ISO 8601, SQL (Ingres), traditional POSTGRES (Unix date format), or German. The default is the ISO format.