Change Date on Columns to Date of I_DATETIMESTAMP


How to Change the Date on Columns to the Date of I_DATETIMESTAMP?


Since both fields are strings, an SQL update statement that concatenates a substring of I_DateTimeStamp and O_CallStartTime should work.

Note: The time stamp itself should not be touched.