Oracle’s default date format is YYYY-MM-DD, WHY?

by

Are you sure you’re not confusing Oracle database with Oracle SQL Developer?

The database itself has no date format, the date comes out of the database in raw form. It’s up to the client software to render it, and SQL Developer does use YYYY-MM-DD as its default format, which is next to useless, I agree.

edit: As was commented below, SQL Developer can be reconfigured to display DATE values properly, it just has bad defaults.

More Related Contents:

  1. Formatting DATE in oracle
  2. ORA-01843 Not a valid month
  3. How to uninstall / completely remove Oracle 11g (client)?
  4. How can I set a custom date time format in Oracle SQL Developer?
  5. Get counts of all tables in a schema
  6. Determining location of relevant tnsnames.ora file
  7. Default row ordering for select query in oracle
  8. oracle convert unix epoch time to date
  9. Oracle trigger after insert or delete
  10. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  11. Difference between a user and a schema in Oracle?
  12. Base64 encoding and decoding in oracle
  13. What is the dual table in Oracle?
  14. how to export data from log table to email body in oracle
  15. How to avoid variable substitution in Oracle SQL Developer
  16. Recursion In Oracle
  17. creating parameterized views in oracle11g
  18. How to send email using Oracle 10 g Forms
  19. How to get primary key column in Oracle?
  20. How to create a user in Oracle 11g and grant permissions
  21. Table-Valued Functions in ORACLE 11g ? ( parameterized views )
  22. Trigger to enforce M-M relationship
  23. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  24. Oracle: how to INSERT if a row doesn’t exist
  25. Valid Date Checks in Oracle
  26. Functions vs procedures in Oracle
  27. Oracle: difference between max(id)+1 and sequence.nextval
  28. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  29. How to generate a version 4 (random) UUID on Oracle?
  30. Find out the history of SQL queries

Leave a Comment