Mysql get date difference in hours

Mysql date between two dates

-- 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';

Mysql get date diff in months

SELECT TIMESTAMPDIFF(MONTH, '2012-05-05', '2012-06-15')

Source: stackoverflow.com

Mysql get date difference in hours

SELECT TIMESTAMPDIFF(HOUR, '2021-05-22 07:00:00', '2021-05-22 12:00:37') as time_diff_in_hours;

Mysql date diff in seconds

SELECT TIME_TO_SEC(TIMEDIFF('2021-05-22 12:00:00', '2021-05-22 12:00:37')) as diff_in_seconds;

Similar codes

2 votes205 views1 answer
Datetrunc
SQL
0 vote197 views1 answer
Get db connection detail from sql developer profile
SQL
3 votes216 views1 answer
Oracle show trigger code
SQL
0 vote206 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote186 views1 answer
Sql select maximum column with other columns returned
SQL
7 votes215 views5 answers
Oracle alter table
SQL
2 votes243 views1 answer
Tcl in sql
SQL
0 vote215 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote222 views2 answers
Check if sql temp table exists
SQL
0 vote222 views1 answer
Check command
SQL