Thursday, 25 August 2016

Query To Get The Number of Seconds or Minutes or Hours Between Two Given Dates

For the Seconds:-
-------------------

SELECT ('Your first Date'-'Your another Date') * DECODE( UPPER('SS')
, 'SS', 24*60*60
, 'MI', 24*60
, 'HH', 24, NULL )
FROM DUAL;

Example:-
SELECT (SYSDATE+1-SYSDATE) * DECODE( UPPER('SS')
, 'SS', 24*60*60
, 'MI', 24*60
, 'HH', 24, NULL )
FROM DUAL;

For Minutes:-
---------------

SELECT ('Your first Date'-'Your another Date') * DECODE( UPPER('MI')
, 'SS', 24*60*60
, 'MI', 24*60
, 'HH', 24, NULL )
FROM DUAL;

Example:-
SELECT (SYSDATE+1-SYSDATE) * DECODE( UPPER('MI')
, 'SS', 24*60*60
, 'MI', 24*60
, 'HH', 24, NULL )
FROM DUAL;

For the Hours:-
-----------------

SELECT ('Your first Date'-'Your another Date') * DECODE( UPPER('HH')
, 'SS', 24*60*60
, 'MI', 24*60
, 'HH', 24, NULL )
FROM DUAL;

Example:-
SELECT (SYSDATE+1-SYSDATE) * DECODE( UPPER('HH')
, 'SS', 24*60*60
, 'MI', 24*60
, 'HH', 24, NULL )
FROM DUAL;

Thanks
Amar Alam

99 comments:

Shalini said...

This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.

seo company in chennai

smarther3 said...

This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.
iOS Training in Chennai

ERP said...

oracle fusion financials online training at erptree.com is worlds best online training center. we have excelled in knowledge sharing through online. we have almost all country students as our subscribers for online course. 10+ years of experience we have in handling various ascent people.
we have user friendly website where you will be provided with all the required details and Self-paced DEMO videos

oraclehcm said...

Thanks for Share These valuable information.Very interesting to read this article. If you are looking for best Oracle fusion online coaching. We provide the low price of fee for on-line coaching.
Oracle fusion financials training

Anonymous said...

Thank you for this great article which is about query to get numbers of seconds .keep more updates.
Digital marketing company in Chennai

shalinipriya said...

Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.
Data Science Training in Chennai

Data science training in bangalore

online Data science training

Data science training in pune

Data science training in kalyan nagar

Data science training in Bangalore

Data science training in tambaram

Data science training in kalyan nagar

akash thakur said...

hi, nice information is given in this blog. Thanks for sharing this type of information, it is so useful for me. nice work keep it up.laminated pine doors manufacturers in karnataka

Unknown said...

Thanks for the informative article. This is one of the best resources I have found in quite some time. Nicely written and great info. I really cannot thank you enough for sharing.

java training in chennai | java training in bangalore

java online training | java training in pune

selenium training in chennai

selenium training in bangalore

Mounika said...

I am really very happy to find this particular site. I just wanted to say thank you for this huge read!! I absolutely enjoying every petite bit of it and I have you bookmarked to test out new substance you post.
python training in velachery
python training institute in chennai

ganga pragya said...

Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information..
angularjs online Training

angularjs Training in marathahalli

angularjs interview questions and answers

angularjs Training in bangalore

angularjs Training in bangalore

angularjs Training in chennai

Anonymous said...


Awesome post, Great information shared with us.keep on posting new things.check it once
aws online training
aws training in hyderabad
aws online training in hyderabad

Anbarasan14 said...

Excellent blog!!!Thanks for sharing. Keep doing more.

French Language Classes in Mulund
French Training near me
French Coaching Classes in Mulund
French Classes in Mulund West
German Training Institute in Mulund
German Course in Mulund East
Best German Coaching Center in Mulund

sandhiya said...

I am really enjoying reading your well written articles.
It looks like you spend a lot of effort and time on your blog.
I have bookmarked it and I am looking forward to reading new articles. Keep up the good work..
Hadoop Training in Chennai
Big Data Training in Chennai
Big Data Course in Chennai
hadoop training in bangalore
big data training in bangalore

Vicky Ram said...

Excellent post! keep sharing such a post

Article submission sites
Education

VenuBharath2010@gmail.com said...

Extra-ordinary Post. Amazing way of handling things. It shows your great understanding of the subject. Thanks for Sharing.
Informatica Training in Chennai
Informatica Training Center Chennai
Informatica course in Chennai
Informatica Training center in Chennai
Informatica Training chennai
Informatica Training institutes in Chennai
Informatica Training in OMR
Informatica Training in Porur
Informatica Training in Tambaram

Aparna said...


You are giving the post is too good and The content is very useful for me. Thanks for your brief explanation with sharing and Keep posting...!
Excel Training in Chennai
Advanced Excel Training in Chennai
Tableau Training in Chennai
Pega Training in Chennai
Oracle DBA Training in Chennai
Unix Training in Chennai
Power BI Training in Chennai
Oracle Training in Chennai
Excel Training in Chennai
Advanced Excel Training in Chennai

sathyaramesh said...

Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us. Do check Cloud Computing Courses in Chennai |
Cloud Computing Training in Chennai Get trained by an expert who will enrich you with the latest updates.
Cloud Computing Training in Chennai
Data Science Course in Chennai
Devops Training in Chennai
Digital Marketing Course in Chennai
Selenium Training in Chennai
Cloud Computing Training in Tambaram

Ajish said...

Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
Angular Js training in Electronic City

jaanu said...

Actually I read it yesterday but I had some thoughts about it and today I wanted to read it again because it is very well written.
AI course malaysia

Softgen Infotech said...

Such a great word which you use in your article and article is amazing knowledge. Thank you for sharing it.

Became An Expert In UiPath Course ! Learn from experienced Trainers and get the knowledge to crack a coding interview, @Softgen Infotech Located in BTM.

Softgen Infotech said...

Very interesting, good job and thanks for sharing such a good blog. your article is so convincing that I never stop myself to say something about it. You’re doing a great job. Keep it up…

Softgen Infotech is the Best Oracle Training institute located in BTM Layout, Bangalore providing quality training with Realtime Trainers and 100% Job Assistance.

Training for IT and Software Courses said...

Excellent post for the people who really need information for this technology.

sap solution manager training in bangalore

sap security training in bangalore

sap grc security training in bangalore

sap ui5 training in bangalore

sap bods training in bangalore

sap apo training in bangalore

sap gts training in bangalore

sap simple logistics training in bangalore

digitaltucr said...


Truly, this article is really one of the very best in the history of articles. I am a antique ’Article’ collector and I sometimes read some new articles if I find them interesting. And I found this one pretty fascinating and it should go into my collection. Very good work!
data science training in bangalore
data science interview questions

Truly, this article is really one of the very best in the history of articles. I am a antique ’Article’ collector and I sometimes read some new articles if I find them interesting. And I found this one pretty fascinating and it should go into my collection. Very good work!
data science training in bangalore
data science interview questions

RIA Institute of Technology said...

Thanks for this informative blog...
AWS Training in Bangalore | AWS Cours | AWS Training Institutes - RIA Institute of Technology
- Best AWS Training in Bangalore, Learn from best AWS Training Institutes in Bangalore with certified experts & get 100% assistance.

emedkit said...


If you’re looking for a medicine to treat the infections caused by Coronavirus, buy Lopikast tablets by Emedkit at the best Lopikast 200mg/50mg Tablets price as we export the medicines in China, Russia, USA, Peru & Romania among many other countries.

NICT CSP said...


Thanks for sharing such a great information, Here we are India's best service provider of SBI Kiosk Banking.
csp apply
csp registration

datasciencecourse said...

Excellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites! Thanks for sharing. Great websites!
machine learning course

artificial intelligence course in mumbai

svrtechnologies said...

I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this sap bi tutorial , I feel happy about it and I love learning more about this topic.

emedkit said...

Emedkit are a global pharmaceutical company whose mission is to advance the well-being of people around the world especially in countries like India, USA, Russia, Romania, Peru, and China. Our products include treatments for diseases such as Ledifos tablets, HIV/AIDS, Cancer, Hepcinat Lp tablets, Cancer Medicine. We provide our products at the lowest possible price as we stock bulk qualities and we deal both in drop shipping and bulk shipping.

Velakast tablets price in India

Myhep lvir tablet price

Lopikast 200mg/50mg Tablets price

svrtechnologies said...

This is so elegant and logical and clearly explained. Brilliantly goes through what could be a complex process and makes it obvious..

sapui5 training

Joyal said...

Effective blog with a lot of information. I just Shared you the link below for ACTE .They really provide good level of training and Placement,I just Had Artificial Intelligence Classes in ACTE , Just Check This Link You can get it more information about the Artificial Intelligence course.

Java training in chennai | Java training in annanagar | Java training in omr | Java training in porur | Java training in tambaram | Java training in velachery

Anonymous said...

Hey guy's i have got something to share from my research work
Louiz
Redox-os
https://diigo.com/0hmsvz

Amit said...

I liked your blog and its information is very unique and useful. Thanks

Artificial Grass Dealers in Bangalore | Artificial Grass Price | Artificial Grass Wholesalers

devi said...

Great post i must say and thanks for the information. Education is definitely a sticky subject. However, is still among the leading topics of our time. I appreciate your post and look forward to more. Data Science Training In Chennai | Certification | Data Science Courses in Chennai | Data Science Training In Bangalore | Certification | Data Science Courses in Bangalore | Data Science Training In Hyderabad | Certification | Data Science Courses in hyderabad | Data Science Training In Coimbatore | Certification | Data Science Courses in Coimbatore | Data Science Training | Certification | Data Science Online Training Course

Sharath said...

You post is very informative and contents are outstanding. Thanks for sharing such useful info.

Zikia | OJOPLUS | Best Immune Booster Tablets in India

hrithiksai said...

Very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing, best data science courses in Hyderabad

datasciencecourse said...

Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article.

Simple Linear Regression

Correlation vs covariance

KNN Algorithm

Logistic Regression explained

EXCELR said...

I am really enjoying reading your well written articles. It looks like you spend a lot of effort and time on your blog. I have bookmarked it and I am looking forward to reading new articles. Keep up the good work. data science training in Hyderabad

Rohini said...

I have bookmarked your website because this site contains valuable information in it. I am really happy with articles quality and presentation. Thanks a lot for keeping great stuff. I am very much thankful for this site.
data science training in Hyderabad

designinnovation said...

From a huge range of products – carpet, laminate, vinyl, bamboo, hardwood, engineered timber, blinds and shutters – to stellar service and helpful expert advice, it’s all under one roof at Campbelltown Carpet Court in Sydney, Australia.

Tableau Training in Hyderabad said...


Nice article and thanks for sharing with us. Its very informative




Plots in THIMMAPUR

Best Training Institute said...

It was so nice content.I was really satisfied by seeing this content.

Sap Pp training in bangalore

Realtime Experts said...

Its really helpful for the users of this site. I am also searching about these type of sites now a days.
IBM Training in Bangalore

Realtime Experts said...

Awesome links, it has helped me a lot. Thanks for sharing.
SQL Server DBA Training in Bangalore

data scientist course said...

I curious more interest in some of them hope you will give more information on this topics in your next articles.
data scientist training and placement

s said...

Pollution mask, Dust Mask and n95mask online - Moksha Mask have plethora of these masks that you can buy online and at the best prices. This online mask store, with its ground-breaking air circulation technology, allows one to breath freely and easily while pursuing strenuous aerobic activities. Moksha Mask provides cost-effective and eco-friendly masks that is reusable, washable and the n95 filter is consumable. Buy n95 masks online has an innovative technology that that enhances air intake and exhalation, with smooth inlet and exhaust fans running on rechargeable battery. With n95 filtration, Moksha Mask assists protect against PM 2.5 and other foreign and harmful particles, dusts and pathogen. A wearable air purifier at INR 15 per day Moksha Mask make sure that breathing pure air doesn’t make hole in your pocket.

Willim said...

Very useful! On-demand appdevelopment solution.

INFYCLE TECHNOLOGIES said...

Infycle Technologies, the best software training institute in Chennai offers the leading Data Science course in Chennai for tech professionals, freshers, and students at the best offers. In addition to the Data Science course, other in-demand courses such as Python, Cyber Security, Selenium, Oracle, Java, Power BI, Digital Marketing also will be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.

poojasharma said...

Wait no more and contact us to watch your website flourish!
https://thewebgross.com/website-designing-services-delhi-india/

yadongbizz said...

Beautiful. However those who suffered losses and may not feel quite so charitable are no less deserving of our good wishes at this time 일본야동

Also feel free to visit may webpage check this link
한국야동

yadongbizz said...

Awesome dispatch! I am indeed getting apt to over this info, is truly neighborly my buddy. Likewise fantastic blog here among many of the costly info you acquire. Reserve up the beneficial process you are doing here. 한국야동닷컴

Also feel free to visit may webpage check this link
국산야동

Anonymous said...

Are you thinking about Business Setup in Dubai? Dont go beyond.Find here affordable business center in sheikh zayed road.

bhavanachouhan said...

Thanks for posting such grateful information. It's pretty nice and very helpful contents in this article.

Sojat Henna Powder Suppliers in India | Henna Powder Suppliers in India

Ramesh Sampangi said...

Nice blog and informative content. Really useful for many people, I bookmarked your website for further blogs. Thanks, you.
Best Data Science Training in Hyderabad

Connect Business Center said...

Connect is the Business Center that offers an ideal choice for fledging companies to easily establish with instant, flexible and ready to use professional office spaces and wide range of services to set up quickly.

Anonymous said...

perde modelleri
sms onay
mobil ödeme bozdurma
NFT NASIL ALINIR
ankara evden eve nakliyat
Trafik Sigortası
dedektör
web sitesi kurma
aşk kitapları

Career Programs Excellence said...

Get a comprehensive overview of Data Science and learn all the essential skills including collecting, modeling, and interpreting data. Register with Data Science institute Bangalore and build a strong foundation for a career where you will be involved in uncovering valuable information for your organization. Learn Python, Machine Learning, Big Data, Deep Learning, and Analytics to take center stage in Data Science.
Data Science in Bangalore


Professional Courses and Training said...

360DigiTMG offers the best Data Analytics courses in the market with placement assistance. Enroll today and fast forward your career.


Data Scientist Course in Delhi

mitchelljohnson9991 said...

Do you desire more website traffic without having to spend a lot of money? For your internet business, are you looking for a reputable SEO Agency in Delhi ? If so, let's assist you. We are a digital marketing firm with our headquarters in Delhi, and our search engine optimization (SEO) solutions have benefited numerous organisations. Our SEO specialists raise your website in the Google search results using best-in-class techniques and high-end equipment.

mitchelljohnson9991 said...

Appear on the top of the search results without waiting for months by Our PPC Services in India. Even if you launched the website yesterday, you could start getting relevant traffic through our PPC campaign services. We create well-structured google ads with the right set of keywords, making it easier to beat the competition. With our best PPC advertising services in India, you will start getting hot leads from Day One without spending a fortune.


mitchelljohnson9991 said...

As a Reputable website designing Agency in Noida, India, we provide consultancy service to the clients. We provide advice, serve as designers and developers, and meet all of the client's needs. The shadow side of online commerce is presented by website design. Everything has a blueprint created before it is given a physical shape or final look. A blueprint, which was written with the goal of changing it, depicts the state of your company. Our team of professionals and dedicated workers is working to frame your website in an exotic way.

mitchelljohnson9991 said...

Boost your online presence with SEO services Delhi and professional website designing Services in India ! Our team of experts is dedicated to delivering results-driven SEO strategies that drive organic traffic and increase search engine rankings. We offer custom website design solutions that are visually appealing, user-friendly, and optimised for search engines. Our website designs are created to engage visitors, increase conversions, and drive business growth. Whether you're looking to improve your website's search engine optimization, or need a new website designed from scratch, we have you covered.


mitchelljohnson9991 said...

Boost your online presence with SEO Company in Delhi and professional website designing Agency in India ! Our team of experts is dedicated to delivering results-driven SEO strategies that drive organic traffic and increase search engine rankings. We offer custom website design solutions that are visually appealing, user-friendly, and optimised for search engines. Our website designs are created to engage visitors, increase conversions, and drive business growth. Whether you're looking to improve your website's search engine optimization, or need a new website designed from scratch, we have you covered.

mitchelljohnson9991 said...

Maximize your business's online presence with our top-notch Facebook marketing company in India . Take your brand to the next level with targeted ads, engaging content, and expert strategy from our Facebook marketing experts.

vibrantnissan said...

Thanks for sharing wonderful information Nissan maginte on road price in hyderabad

iteducationcentre said...

I really enjoyed reading your article; it was truly awesome! Thank you for sharing your work.
Frontend development classes in Pune

ERP Software provider said...

I like oracle relevant quearies. If you have any issue the connect with ERP Software development companies for solutions

sc said...

Enhance your business's efficiency and streamline operations with SCM Champs' cutting-edge services. Experience the power of S/4HANA, revolutionizing the way you manage your enterprise. Our S/4HANA services
seamlessly integrate all facets of your business, from finance to procurement, production, sales, and more. Empower your team with real-time insights, predictive analytics, and customizable reporting, making informed decisions a breeze.


Efficient transportation management is key to business success, and that's where our Transportation Management services shine. Seamlessly plan, execute, and monitor your transportation operations while reducing costs and enhancing customer satisfaction. Real-time visibility into shipments, route optimization, and compliance management are just a few clicks away.

Revolutionize your warehouse management with our SAP Warehouse Management solutions. Optimize inventory tracking, automate processes, and ensure accurate order fulfillment. Say goodbye to inefficiencies and hello to a well-organized, agile warehouse that adapts to your needs.

Investment Banking Course in India said...

Thanks so much for sharing this article with us! I found it very informative, and I'm sure others will too. Thank you for taking the time to contribute your thoughts and experiences on this topic.
Investment Banking Course in India

Investment Banking Course in Delhi said...

Thanks so much for sharing this article with us! I found it very informative, and I'm sure others will too. Thank you for taking the time to contribute your thoughts and experiences on this topic.
Investment Banking Course in delhi

Ashvin Kumar said...

This is a great article, and I'm happy to share with my friends. I have bookmarked your website for more blogs!
IIM Skills is the best institute to make your career successful with Data Analytics Courses in India. With Excel, Access, and Oracle databases, you can stay up-to-date on current trends and develop innovative solutions.

Vaibhav Kakkar said...

It was a great article on Query To Get The Number of Seconds or Minutes or Hours Between Two Given Dates. I learn something new today. Thank you for posting such informative articles.
Data Analytics Courses in Mumbai

Gayatri said...

Great SQL post by the author. This query provides a versatile solution for calculating time differences in seconds, minutes, or hours, adding value to SQL developers. Kudos!
Data Analytics Courses in Nashik

Shaz Ahmed said...


Exclusive SEO is the premier digital marketing agency in Manchester, offering top-notch SEO, PPC, and a wide range of digital marketing services. Our team of experts is passionate about helping businesses like yours thrive in the digital world.

As being the top SEO Company in Manchester, we firmly believe that effective SEO is the foundation of a successful online presence. Our team of SEO experts is well-versed in the latest algorithms and best practices, ensuring your website achieves higher rankings on search engines.

PPC advertising is a powerful tool to reach potential customers and generate leads instantly. As a leading PPC agency in Manchester
Exclusive SEO is committed to delivering impactful PPC campaigns that maximize your return on investment (ROI).

Anonymous said...

This article likely offers SQL query examples to calculate the time difference in seconds, minutes, or hours between two given dates, a handy resource for database developers dealing with date and time data.

Data Analytics Courses In Kochi



Aruna Sen said...

The author's Oracle Apps Technical World offers invaluable solutions to the Oracle Technical community. The provided SQL queries for calculating time intervals demonstrate his expertise and generosity in sharing knowledge. Great work.
Data Analytics Courses In Dubai

Data Analytics Courses in Agra said...

Counting seconds became quite simple after this explanation. I appreciate your help; I can easily track my time now.
Data Analytics Courses in Agra

Pratyaksha said...

The query for the counting seconds to calculate the time difference between two given dates is incredibly helpful and its really amazing.
Data Analytics Courses In Chennai

Pratyaksha said...

It's easy to understand how it calculates the time difference in seconds, minutes, and hours. Additionally, the use of functions demonstrates SQL's power in handling date and time data.
Data Analytics Courses In Chennai

datavadodara said...

good blog
Data Analytics Courses In Vadodara

datavadodara said...

nice blog
Data Analytics Courses In Vadodara

Advisor Uncle said...

Thank you so much for this wonderful blog. I really loved it.
Visit - Data Analytics Courses in Delhi

Aishwarya said...

Your blog provides a comprehensive understanding of the topic and offers practical solutions.
Data analytics courses in new Jersey

Surabhi said...

A query to calculate the time difference between two dates can be a valuable tool in database management, allowing you to easily obtain the number of seconds, minutes, or hours between those points in time. This functionality is often used in various applications, from scheduling to data analytics.
Please also read Data Analytics courses in Glasgow .

DA in limerick said...

The idea to help Oracle Technical community is incredible and excellent and helps to get valuable knowledge.
data analyst courses in limerick

Sayaniimskillsseo said...

very well written blog, insightful & informative.
Digital Marketing Courses In port-harcourt

DMC in Bhutan said...

Thank you for sharing valuable and informative query to calculate the time difference between two dates .
Digital Marketing Courses In Bhutan

sayaniimskillseo said...

thanks for sharing such interesting information
Digital marketing business

Digital marketing tips for small businesses said...


Great SQL tutorial! Your clear explanations and examples make it easy to understand. Thanks for sharing your expertise on date calculations.

Digital marketing tips for small businesses

Investment banking courses after 12th said...
This comment has been removed by the author.
Kenny Sen said...
This comment has been removed by the author.
Investment banking courses after 12th said...

Deeply appreciate the author's ability to teach in a simple manner. Nice post.
Investment banking courses after 12th

Kenny Sen said...

Thanks for sharing information SQL tutorial.
Investment banking courses in the world

Brymos Kitchen said...

Best Residential Interior Designers in Mulund
Best Modular kitchen manufacturers in Thane

GCP MASTERS said...

thanks for valuable info
gcp training in hyderabad

Gogou Misao said...

Great blog post. Just the info I needed.

Investment banking analyst jobs

Strive dental said...

Pediatric Dental Service in surrey
Orthodontic Dental Service in surrey

Strive dental said...

Emergency Dentist in Surrey
Pediatric Dental Service in surrey
Orthodontic Dental Service in surrey
Average cost for dental x rays in surrey
Hygiene Dental Service in surrey

White wave said...

best tourist visa consultants in punjab
UK Study Visa consultants in Mohali
Top Immigration Consultants For Uk in Mohali
Canada study visa Consultants in Mohali
work permit visa consultant in Mohali
Best study and Tourist visa consultant in Mohali

Post a Comment