Awesome DATE / TIMESTAMP enhancement in Autonomous Database
Date management is a commonly encountered issue when customers want to move their database to a cloud environment. If you
Date management is a commonly encountered issue when customers want to move their database to a cloud environment. If you
One of the most commonly hit questions on AskTom is how to count the number of work days (Mon =>
We had an interesting AskTom question recently, about why certain TRUNC commands would generate an error when applied to a
We had question in the OpenWorld panel about why queries on date columns are “always slow”. Well….they aren’t but here’s
Richard Foote has written a post about not using the DATE datatype for storing dates. So I’ve come up with
You might be thinking “Nothing is more frustrating that encountering a string column that is full of dates”. But there
This post seems timely given that yesterday was Feb 29. In almost every case I can think of, you should
Notice in all of the examples below that the date string does not match the format mask. When a date
There’s a somewhat sour discussion going on based attached to the video at https://www.youtube.com/watch?v=jZW-uLb52xk Whether you agree or disagree with