xxxxxxxxxx
// get difference in Seconds / Minutes / Hours between two dates
SELECT
time_diff_in_hours AS totalSeconds,
(time_diff_in_hours / 60) AS totalMinutes,
(
(time_diff_in_hours / 60) / 60
) AS totalHours,
ROUND(
(
(time_diff_in_hours / 60) / 60
),
2
) as roundOff
FROM
(
SELECT
TIMESTAMPDIFF(
SECOND, '2022-11-23 01:01:00', '2022-11-24 02:11:00'
) AS time_diff_in_hours
) AS results
xxxxxxxxxx
SELECT TIMESTAMPDIFF(HOUR, '2021-05-22 07:00:00', '2021-05-22 12:00:37') as time_diff_in_hours;
xxxxxxxxxx
ex1:
SELECT * FROM `objects`
WHERE (date_field BETWEEN '2010-01-30 14:15:55' AND '2010-09-29 10:15:55')
ex2:
WHERE
requireddate BETWEEN
CAST('2003-01-01' AS DATE) AND
CAST('2003-01-31' AS DATE);
xxxxxxxxxx
-- With implicit CAST
SELECT * FROM my_table
WHERE my_date BETWEEN '2021-06-01 01:12:00' AND '2021-06-30 23:59:59';
-- is EQUIVALENT to
SELECT * FROM my_table
WHERE my_date >= '2021-06-01 01:12:00' AND my_col <= '2021-06-30 23:59:59';