Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF(SELECT MAX(DateAdded) FROM RestoreDetectors " +
- " WHERE CONVERT(VARCHAR,DateAdded,101) = CONVERT(VARCHAR,GETDATE(), 101) " +
- " AND DATEDIFF(SECOND, DateAdded,GETDATE()) <= {0}) IS NULL"
- IF(SELECT MAX(DateAdded) FROM RestoreDetectors
- WHERE DATE_FORMAT(DateAdded,'%m/%d/%Y') =
- DATE_FORMAT(NOW(),'%m/%d/%Y')
- AND TIMESTAMPDIFF(SECOND,DateAdded,NOW()) <= ? ) IS NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement