to_char(dt,’yyyy’) is almost as good as trunc(dt,’y')…
I’m in the middle of updating Expert Oracle Database Architecture Edition 1 to Edition 2. It’ll cover up through Oracle Database 11g Release 2. While doing it, I’ve been discovering that “things change over time”. Well, Ok, that is not a new discovery – I’ve said that before… If you are interested in the new [...]