SQL & PL/SQL

Hi all,

I need to compare two dates. One is the system date. The other one is a user input.

But,when I try to run the following query, the output is wrong.

SELECT TO_DATE(SYSDATE,'DD-MM-YYYY') FROM DUAL;

The output of this is coming as 'DD-MON-YYYY', not as 'DD-MM-YYYY'.

Is this a known issue or what?

Please guide me in-order to compare following date with the system date.

2017-05-25 - Input date

Thanks.