'Date format in oracle PL/SQL
How to check the date format for a specific column in a table in oracle? Does oracle DATE datatype have the ability to store both formats (US and european)? and if so, is there a way to distinguish which one is the month and which is the date?
Solution 1:[1]
Oracle dates are stored in an internal binary data format. Display formatting is handled by the client and is not stored.
This is the same as for numbers, for example, where the same value can be displayed as 1000, 1,000.00, 1e3 etc depending on the format mask used with the to_char function.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | William Robertson |