Oracle - Filter by date

4

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?

    
asked by anonymous 11.06.2018 / 18:29

1 answer

3

The error says that the format reported (DD / MM / YYYY) ends before converting the input string, because in the format there is no time and the parameter has.

Then just take the time (00:00:00):

AND ma.dt_atualiza_log >= to_date('01/01/2018','DD/MM/YYYY')
    
11.06.2018 / 18:43