Thank you. I am aware of that.

Triggers on INSERT and UPDATE are the 'back up' if I can not come up with a better way.

Possible to do one trigger on the whole DB to be fired for a specific data type? Otherwise a trigger is not pratical as there are over 500 columns...

I need the conversion to happen automatically, with out any action by the user or applications using the DB. There are multple apps that access the DB. Some...

I am attempting to have a column where there is no date portion. Only a time portion. Your example will keep the date portion specified. That needs...