how can I get the datas from a table where dateOut - dateIn > 1 hour
Select id from myTable WHERE dateOut - dateIn > 1
return > 1 day
I have tried :
Select id from myTable WHERE hour(dateOut - dateIn) > 1
the difference is ok but between dates not in the same day !!!
how can I do that ?
thank you