I am saving in my database the date when a particular record is changed, but the format it is saved is (YYYY-MM-DD) , the SQL command used so far is the following:
update public.transportadora set status = 'Ativo', user_update = 'Teste', data_alteracao = current_date where codigo = 3
and the registry looks like this:
My need is for the date to be in the DD-MM-YYYY sequence, ie 27/03/2017