dates – Learning is not a spectator sport

Counting business days between 2 dates

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