query select dates more than one hour

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • cdt_sylvestre

    query select dates more than one hour

    hi,
    i'm searching for the mysql query which can gave me frome DATE_TIME mysql
    variable which lines are more than an hour

    i can do that with days with
    SELECT * FROM clients WHERE TO_DAYS(NOW())-TO_DAYS(date)>7

    thx


Working...