a difference of 1 hour between 2 dates

[gwendaal]

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