The existing stored data would stay as it is. It would be automatically converted to datetime on query. The new data that's coming in would be stored as datetim

The existing stored data would stay as it is. It would be automatically converted to datetime on query. The new data that's coming in would be stored as datetime. From user's perspective, the change would be instant.