Something change recently (Oracle upgrade and/or new gem) that’s
causing ActiveRecord to give me very unfriendly dates from Oracle.
I believe the old dates I was getting were “YYYY-MM-DD”. The ones I’m
getting now are like this:
Tue Dec 23 00:00:00 -0600 2008
Oddly enough, telling my ActiveRecord subclass to fetch “select to_char
(thedate,‘YYYY-MM-DD’) as thedate” is not working, as I’m still
receiving the very long date listed above.
I found reference to this somewhere online: ALTER SESSION SET
NLS_DATE_FORMAT = ‘YYYY-MM-DD’
I have executed that in my app, but subsequent queries are still
returning the long date.