Posts by Juliano Santos • 11 points

• 0

  votes

  2

  answers

  1461

  views

  A: Check last records per hour

  There is that way too: $data_hora_intervalo = date('Y-m-d H:i:s', strtotime('-1 hour', strtotime(date('Y-m-d H:i:s')))); where data>='$data_hora_intervalo'

  php mysql

  answered 8 years ago Juliano Santos 11

• 1

  votes

  2

  answers

  1461

  views

  A: Check last records per hour

  For me what Sergio said it worked: WHERE data >= DATE_SUB(NOW(), INTERVAL 1 HOUR) Maybe it’s because in the field structure in your table you have put only DATE, place DATETIME you’re here…

  php mysql

  answered 8 years ago Juliano Santos 11