If you're willing to work with Class::DBI, you can specify that this column needs to be passed into some object, like DateTime, that would then do what you wanted it to do.
My criteria for good software:
Does it work?
Can someone else come in, make a change, and be reasonably certain no bugs were introduced?