Mariadb - Calculate Date Difference in Hour
Here Is My Initial Code: Select Order_Logs. Order_Logs_Created, Datediff(Hour, Now(), Order_Logs. Order_Logs_Created) from Order_Logs and I Gave an Error...
Here is my initial code :
SELECT order_logs.order_logs_created, DATEDIFF(HOUR ,NOW(),order_logs.order_logs_created) FROM order_logs
And I gave an error :
#1582 - Incorrect parameter count in the call to native function 'DATEDIFF'
Then , I searched about MariaDB's DATEDIFF and I saw this , I figured out that I can use DATEDIFF with two parameters so I remove HOUR :
SELECT order_logs.order_logs_created, DATEDIFF(NOW(),order_logs.order_logs_created) FROM order_logs
I need time difference in hours , Actually it gives me in days. Any suggestion?
2 Answers
You can use TIMESTAMPDIFF for this:
SELECT
order_logs.order_logs_created,
TIMESTAMPDIFF(HOUR,
order_logs.order_logs_created,
NOW())
FROM
order_logs
Use TIMESTAMPDIFF:
SELECT order_logs.order_logs_created, TIMESTAMPDIFF(HOUR ,order_logs.order_logs_created , NOW()) FROM order_logs
James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.
