SELECT DATEDIFF(DAY, '2023-03-01', '2023-06-09') SELECT DATEDIFF(year, '2017/08/25', '2011/08/25') AS DateDiff;SELECT DATEDIFF('2022-04-08',Date('2022-04-06 20:23:08')) as days, TO_DAYS('2022-04-08') - TO_DAYS(date('2022-04-06 20:23:08')) as todays //hours SELECT TIMESTAMPDIFF(HOUR,NOW(),'2013-05-15 10:23:23') calculates difference in hour.(for days--> you have to define day replacing hour SELECT t1.OrderNo,DATEDIFF(day,t1.LoadedStartDate,t2.LoadedStartDate) FROM UnnamedTableFromQuestion t1 INNER JOIN UnnamedTableFromQuestion t2 on t1.OrderNo = t2.OrderNo WHERE t1.OpNo = 1 and t2.OpNo = 4 //////////////////////////////////////////////////////////////// select cur.unique_id_field, cur.seq_no, cur.date_created , datediff(second, prv.date_created, cur.date_created) as diff_in_seconds from yourtable as cur join yourtable as prv on cur.seq_no = prv.seq_no + 1;