And Then There are the Things That Drive You Crazy

As much as I might love the PL/SQL syntax for types, it’s not without flaws:

Unit                    Valid format parameters
Day                     DDD, DD, J
Start day of the week   DAY, DY, D

Notice how there’s a unit called “Day” and a format parameter “DAY”, but they are not for the same kind of thing. Ohhhh man.