I am in the process of cleaning data in a table containing a column of times which I have already converted to the 'time' datatype. I used the following code to perform the conversion:
alter table PortfolioProjects..NYPD_shootings alter column OCCUR_TIME time
The conversion worked; however, the converted times are in 'hh:mm:ss.0000000' format, whereas I wish to have them in 'hh:mm' format. The converted datatype is listed as time(7). I have searched the internet far and wide for an answer to this question and come up with nothing.
Any assistance would be appreciated.