Question: how to convert date to yyyy mm dd 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.