quando vou inserir a data e hora atual com uma formatação de data da erro, como faço para resolver
Your data type isn’t a text field. I would just recommend saving it as a date field, then when referencing that date field anywhere, use the :formatted as date operator then.
Quer dizer que no banco de dados eu deixo o tipo como texto ?
To save the formatted date in your database, yes. But as I recommended, I would recommend saving it as a date and displaying it as a formatted as date