Oracle’s SQL
Developer (as shipped with 11gR2) has a bug
feature that by default, causes only the date portion of datetime columns to
show in the displayed query results.
Here’s the default
|
And here it is set
to the ISO 8601-style date
YYYY-MM-DD
HH24:MI:SS
|
|
 |
Good luck!
1 comment:
The article provides a practical and insightful look at handling date-related behavior in Oracle SQL Developer 11gR2. The clear focus on understanding date formats, session settings, and consistent query results makes this especially useful for DBAs and developers working with Oracle databases. A concise and valuable reference for avoiding common date-handling issues in real-world database environments.
best spa packages in Lahore
bissino lahore
handmade leather dog harness
Post a Comment