Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
N
N
Noob--Saibot2017-08-22 18:40:48
MySQL
Noob--Saibot, 2017-08-22 18:40:48

How to get records older than one day in mysql?

Hi all. Can you please tell me how to get records from a table with a datetime field older than one day?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
R
Rsa97, 2017-08-22
@Noob--Saibot

WHERE `datetime` < NOW() - INTERVAL 1 DAY

Similar questions
R
rinaz222019-10-18 18:19:06
How to follow the link in the mobile version of the site only after the second click? 5Reply
E
emerysh2017-06-09 00:18:28
How to compare fields from different tables? 1Reply
#
#FFFFFF2019-11-19 14:39:34
What is better to use for e2e testing Vue? 3Reply
V
Vladimir2017-07-04 13:29:51
How to prevent a route change on $routeChangeStart so that $routeChangeError will work after? 2Reply
N
Nikolai Steshenko2021-05-24 00:59:15
How to add a field to registration or remove instantaCms? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question