That is a convenience that causes Ignition's table-creation helpers to use those column types. The critical change is to the table--change the column type.
Yes, it can be a big deal for a system in production. It is best to get the column types correct up front. (For a corporation that has facilities spanning multiple time zones, the plain MS SQL Server datetime column type is a terrible design choice. Your client's DB admins should be chastized.)