I have a column dt_atualiza_log
that is with type DATE
in the table (it is saved in the 01/12/2011 10:10:48 format)
I'm not able to filter on and
of my query . I have tried in many ways, the last one:
AND ma.dt_atualiza_log >= to_date('01/01/2018 00:00:00','DD/MM/YYYY hh24:mi')
Error: ORA-01830: The date format image ends before convert the entire input string
It seems like I'm making a mistake right now. Can you help, please?