I have a date in the American yyyy-mm-dd format and I would like to put it in the Brazilian dd-mm-yyyy format however I do not want to do as to_char conversion. I need it to continue with the date format because I will need to make filters with date range and how string the filter does not work. Poir that the need to change the position of the date, but remaining the date type.
POSTGRES BANK