Advertisement
Guest User

Untitled

a guest
Jul 28th, 2017
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 0.71 KB | None | 0 0
  1. Finde folgenden Code in der GUILD_STR (Datenbank Prozedur)
  2. ACHTUNG: Der Code ist 2 Mal vorhanden!
  3.  
  4. SET m_tGuildMember = CONVERT(CHAR(8),DATEADD(d,2,GETDATE()),112)
  5. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(d,2,GETDATE()))),2)
  6. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(d,2,GETDATE()))),2)
  7. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(d,2,GETDATE()))),2)
  8.  
  9.  
  10.  
  11. Ändere beide zu:
  12.  
  13. SET m_tGuildMember = CONVERT(CHAR(8),DATEADD(mi,30,GETDATE()),112)
  14. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(mi,30,GETDATE()))),2)
  15. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(mi,30,GETDATE()))),2)
  16. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(mi,30,GETDATE()))),2)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement