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
1 view
223
45
8 hours ago 00:29:27 1
I built a FANTASY MUSHROOM CAVE in Minecraft Create Mod
1 day ago 00:06:04 1
The Great Escape of Netaji from Kolkata | Bose vs Gandhi | INA Story l PB Speaks
1 day ago 00:21:38 1
Unturned w/ Youtubers | THE NAKED MILE! | Part 4, Gameplay, Indie Game
1 day ago 00:32:30 1
Papo & Yo | THE CALM AFTER THE STORM... | (Part 7/End) w/ facecam, Gameplay Playthrough