samedi 23 juillet 2016

sql server query about unix time

i have a 4-column table with ships' signal entries. 1st column is unix time with a 3-month rows entry. 2nd is the name of a ship. 3rd is the longitude. 4th is the latitude. There are many entries of the same ship with different time. i want a sql server query, to find the table rows which a ship , doesn't have an entry for more than 10 minutes and less than 5 hours.

Aucun commentaire:

Enregistrer un commentaire