Is there any working way to convert nvarchar data type to time data type?
I have two columns in my table: open, close of the nvarchar data type. They have values like this ’10:50:PM’. they’re supposed to be of the time data type.
I have two columns in my table: open, close of the nvarchar data type. They have values like this ’10:50:PM’. they’re supposed to be of the time data type.