Mariadb - calculate date difference in hour

Question

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?

Gurwinder Singh · Answer 1 · 2017-01-29T06:39:27.663

3

You can use TIMESTAMPDIFF for this:

SELECT 
    order_logs.order_logs_created,
    TIMESTAMPDIFF(HOUR,
        order_logs.order_logs_created,
        NOW())
FROM
    order_logs

edited Jan 29 '17 at 06:39

answered Jan 29 '17 at 06:36

Gurwinder Singh

I've already searched and reached my answer . But Thank you for your answer anyway. The essential difference between your answer any my own is position of now and created. – Farzan Najipour Jan 29 '17 at 06:38

score 0 · Accepted Answer · answered Jan 29 '17 at 06:36

0

Use TIMESTAMPDIFF:

SELECT order_logs.order_logs_created, TIMESTAMPDIFF(HOUR ,order_logs.order_logs_created , NOW()) FROM order_logs

answered Jan 29 '17 at 06:36

Farzan Najipour

2 Answers2