Advertisement
Guest User

Untitled

a guest
Feb 9th, 2016
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. IF(SELECT MAX(DateAdded) FROM RestoreDetectors " +
  2. " WHERE CONVERT(VARCHAR,DateAdded,101) = CONVERT(VARCHAR,GETDATE(), 101) " +
  3. " AND DATEDIFF(SECOND, DateAdded,GETDATE()) <= {0}) IS NULL"
  4.  
  5. IF(SELECT MAX(DateAdded) FROM RestoreDetectors
  6. WHERE DATE_FORMAT(DateAdded,'%m/%d/%Y') =
  7. DATE_FORMAT(NOW(),'%m/%d/%Y')
  8. AND TIMESTAMPDIFF(SECOND,DateAdded,NOW()) <= ? ) IS NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement