Wouldn't it be nice to have a few centrally defined pl/sql functions that return some frequently used date formats, instead of repeatedly using to_char? This would also be a step towards internationalization of the toolkit. For example for a german site I find myself rewriting a lot of to_char(some_date, 'MM/DD/YYYY HH12:MI PM') to to_char(some_date, 'DD.MM.YYYY HH24:MI'), while it would be much nicer to just change a function like oacs_dt_short in only one place.
I am sure this has been discussed before, but I couldn't find where.
