TIMESTAMP - Sean D. Stuber

Looking Through Holes in Time

2018-12-182018-12-18Sean D. Stuber

While testing some date/time functions today I came across an interesting quirk in Oracle’s Gregorian calendar and different date representations. In the Gregorian calendar, the day after October 4, 1582 is October 15, 1582 (not all countries adopted the calendar immediately, so they have different gaps, but Oracle observes the calendar as it was originally…

Strange (erroneous) query from Oracle Audit Vault

2018-09-01Sean D. Stuber

Today I was asked about a query from an Audit Vault job that was failing. Unfortunately, the job didn’t report any useful error messages to explain the failure. After some digging the problem was narrowed down to a query pulling user account information. In particular, a calculated column was proving both erroneous as well as…