Myvideo

Guest

Login

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

Uploaded By: Myvideo
1 view
0
0 votes
0

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

Share with your friends

Link:

Embed:

Video Size:

Custom size:

x

Add to Playlist:

Favorites
My Playlist
Watch Later