Need to compare 2 dates -


i need compare 2 dates/time stamps , see if within 10 minutes of each other in sql. if within 10 minutes of each other, not want data output in. if outside of 10 minutes, output data.

example: if event 1 occurs on saturday 9/10/2017 10:00:00, , event 2 occurs on saturday 9/10/2017 10:00:09, not want data queried.

if event 1 occurs on saturday 9/10/2017 10:00:00, , event 2 occurs on saturday 9/10/2017 10:00:11, want data queried.


Comments

Popular posts from this blog

php - Embed BBCode within itself not working -

three.js - how to load gltf in three JS -

sql server - T-SQL: Access DB objects in same schema without qualifying? -