Discussion Locked
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Could someone help me in identifying number of hours between two given dates in a single SQL using Oracle RDBMS.
3 replies
by basit_jafri
Thats pretty simple man
all the answers to date differences are returned in number of days by default in oracle.
so if field D2 and D1 contain 2 date elements, then D2-D1 will return number of days even it is less than a day.
Every day has24 hours then ur statement to get no of hours between two statemsnts should be
SELECT (DATE2 - DATE1 ) * 24 FROM TABLE
this is the simplest and effective way to do this, hope ur satisfied
BA
Poster rated this answer
This question was closed by the author
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
0 helpful
1 reply
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies
Question
Windows and macOS computers becoming slow or unstable after updates - what should I check first
0 helpful
1 reply
Discussion
Optimizing WordPress widgets and DOM size
0 helpful
3 replies