这个小功能怎么实现

Question

现在要获取系统的时间 小时分秒 如130101 六位字符串 补零

Answer 1

select rtrim(datepart(hh,GETDATE()))+
       rtrim(datepart(mi,GETDATE()))+
       rtrim(datepart(ss,GETDATE()))
  

Answer 2

select replace(CONVERT(varchar(10),getdate(),108),':','')
/*----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
141158(1 行受影响)*/

Answer 3

select replace(CONVERT(varchar(8),GETDATE(),114),':','')

Answer 4

select replace(right(convert(varchar(19),getdate(),120),8),':','')