Change to readable date format

Trigger to insert date into table in the form of

01/01/00 12:00:00

instead of SQL standard date format

2000-01-01 12:00:00.000

This allows easily comparing to or updating based on
Oracle date formats or a readable format for the web.

triggername - name of the trigger
TABLENAME - name of the table that trigger is created on
COLUMNNAME - name of column in TABLENAME that will be updated with the output

I use this script to populate a HEADER column in a SQL2005 table and then I can export to a flat file and insert into an Oracle table. I also use this as a user defined function to post a readable date format to the web.