david.shin has asked for the wisdom of the Perl Monks concerning the following question:
I have a record set from an oracle DB and one of the columns is a date/time field.
Oracle spits me back DD-MMM-YY, but i need it in the format of YYYYMMDD.
I've googled it, but haven't turned up anything useful.
Right now I have a regex that converts it for me, but it's not fool proff since I only have the last 2 digits of the year (i use a check of YY > 10, then 19YY else 20YY).
Is there a global setting for DBI that I can set so it knows to convert dates in a certain format?