The date format in Oracle SQL Developer looks like DD-MON-YY
.
For example 17-OCT-03
.
The date format in APEX looks like MM/DD/YYYY
.
For example 12/17/1980
.
Why are they different?
This might cause the same SQL query not to work on both applications.
I know that I can avoid such problem by using TO_DATE and TO_CHAR functions but I want to understand the logic behind this problem.
Does every application use its own default date format?