By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT TRY_CONVERT(time,'7:43 am'); --works
| (No column name) |
|---|
| 07:43:00 |
CREATE TABLE dbo.YourTable (YourTime time);
INSERT INTO dbo.YourTable (YourTime)
VALUES ('7:43 am'); --Works
SELECT *
FROM dbo.YourTable;
| YourTime |
|---|
| 07:43:00.0000000 |