SET m_tGuildMember = CONVERT(CHAR(8),DATEADD(d,2,GETDATE()),112)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(d,2,GETDATE ()))),2)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(d,2,GETDATE ()))),2)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(d,2,GETDATE ()))),2)
which line should I replace with this one DATEADD(mi,10,GETDATE()))),2) ?
 |
