By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
declare @p varchar(100) = CONVERT(varchar(100),getdate(),21);
select @p;
set @p = SUBSTRING(@p,1,11) + '11' + SUBSTRING(@p,14,LEN(@p))
select @p;
| (No column name) |
|---|
| 2023-10-06 03:19:38.313 |
| (No column name) |
|---|
| 2023-10-06 11:19:38.313 |
declare @p varchar(100) = CONVERT(varchar(100),getdate(),21);
select @p;
set @p = STUFF(@p,12,2,'11')
select @p;
| (No column name) |
|---|
| 2023-10-06 03:19:38.313 |
| (No column name) |
|---|
| 2023-10-06 11:19:38.313 |