How to calculate difference between two timestamps in SQL | Datediff in sql | Ashutosh Kumar

Sql one of the most important language asked in most of the analytics interviews, in this video i am discussing about a very important concept in sql which is calculating difference between two timestamp in terms of hours , minutes and seconds using datediff function in sql. So do watch the video till the very end. 👉 Query - drop table if exists details; CREATE TABLE details(Timing1 TIME, Timing2 TIME); INSERT INTO details(Timing1,Timing2) VALUES(’10:50:00’,’12:30:00’), (’12:30:00’,’13:52:00’), (’05:45:00’,’09:00:00’); select * from details; 👉 Complete playlist on Sql Interview questions and answers --------------------------------------------------------------------------------------------------------------------- Check out some more relevant content here 👉 How to Learn SQL
Back to Top