> The guy *is* storing dates as dates in the database.

Yep. Now the situation is clear. But in the initial message he only
said that he want this formatting to be done *in triggers*. Triggers are
fired on DML and whatever they do, the result is *stored* (or trashed).

SY, SD.

PS: I also think that date formatting is better to be done by "XML
parsing application".