.... Or if your database isn't too complicated, you could create a view for
each table using the CONVERT function on your date fields. Your select
statement could then be done on the view rather than the table directly.
This would return a character representation of your date field in the
format you want.