I have field REPORTDATE (DATETIME).
In SQL Developer i can see its value in this format
I found that in order to do the select of just a DATE I need to execute this:
SELECT TO_DATE (REPORTDATE, 'DD.MON.YYYY') AS my_date FROM TABLE1
but it returns
0RA-01843: not a valid month
I want result to return only 29.10.2013