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
3 days ago 00:05:17 1
The Ultimate Email Extractor in 2024: YellowPages Scraper 🌎
3 days ago 00:03:55 1
Pokemon GO Joystick, Teleport, Auto Walk - How to Get Pokemon GO Spoofer iOS & Android 2024 FREE
3 days ago 00:12:05 1
ZenBusiness Review 2024: What Makes It Stand Out?
4 days ago 00:04:14 1
Paramore: Decode [OFFICIAL VIDEO]
4 days ago 02:01:18 1
Half-Life 2: 20th Anniversary Documentary
4 days ago 00:36:24 2
Best of the Worst Trivia!
4 days ago 00:03:07 1
Delta Executor iOS iPhone Android NO KEY - Roblox Script Executor Mobile NEW UPDATE 2024
5 days ago 00:03:04 1
Bach, Organ Sonata No. 4 in E minor (BWV 528) 3. Un poco Allegro.
5 days ago 00:04:49 1
Play To Earn🔥This New Play to Earn Game is About to Make a Lot of People RICH
1 week ago 00:03:04 1
Arena Of Valor Hack - How to Get Unlimited Vouchers! iOS Android