Reformat the date outside of the database is silly. Not sure why that was the ACS approach, because it's twice as much work as just having the DB spit out the format you want in the first place. (First you have to parse the db's format, then reformat.)
Just saying: "select * from foo" and then do the reformatting with a proc is somewhat quicker than specifying a bazillion columns, like you have to do if you let the db do the formatting...
I'm not sure if this justifies "silly" behaviour but might be an explanation😊
