declare @d datetime = GETDATE() declare @date varchar(10) = CONVERT(varchar, @d, 120); declare @time varchar(10) = REPLACE(CONVERT(char(8), @d, 108), ':', '-' ); declare @datetime varchar(20) = @date + '_' + @time select @datetime 出力--> 2021-11-22_17-37-33