Selecting records from DB in a time interval?

0 like 0 dislike
6 views
Screenshot database prntscr.com/jcsbqo
There is such a request, but he did not choose the right value.
SELECT `ip_adreess` FROM `requests` WHERE `date_create` >= DATE_SUB(CURTIME(),INTERVAL 1 HOUR);
You need to choose `ip_adreess` in the period of the current time - 1 hour, how to do it?
by | 6 views

1 Answer

0 like 0 dislike
CURTIME() returns only the time without date. Use NOW().
by

Related questions

0 like 0 dislike
2 answers
How to make selecting records from two tables?
asked Apr 11, 2019 by artmirarmi
0 like 0 dislike
1 answer
As in sqlite, simply access the records for the interval?
asked Jun 7, 2019 by Mayzer
0 like 0 dislike
1 answer
How do I output the first 3 rows from dB?
asked May 22, 2019 by lexa_gorchakov19

Most popular tags

javascript php css html jquery wordpress python linux web-development mysql android windows java layout c# computer-networks node.js cpp iron yii vue.js 1C-Bitrix react laravel django nginx system-administration search-engine-optimization api ubuntu the-it-education. ajax sql programming hosting cms design apache google-chrome bootstrap Vkontakte macos google network-administration git laptops algorithms regular-expressions unity-game-engine email angular database network-equipment software wooсommerce debian .net ios information-security video law-in-it browsers books parsing wi-fi game-development career htaccess postgresql telegram mikrotik mobile-development ruby-on-rails the-domain-name-system modx Yandex c json opencart Habr freelance vpn asp.net windows-server symfony bots hard-drives math qt DIY audio frontend payment-system bash electronics gulp.js user-interface docker online-shopping
110,608 questions
257,186 answers
0 comments
33,932 users