tag:blogger.com,1999:blog-8873109125023142810.post8277102746445577079..comments2024-03-28T16:58:51.302+05:30Comments on Let's Develop in Oracle: Oracle SQL: Date Difference in Days, Months and YearsNimish Garghttp://www.blogger.com/profile/15795821721808548808noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-8873109125023142810.post-56248792834553787752023-09-26T10:46:34.633+05:302023-09-26T10:46:34.633+05:30Nice article.Thanks for the post.
SQL training in ...Nice article.Thanks for the post.<br /><a href="https://www.iteducationcentre.com/sql-training-in-pune.php" rel="nofollow">SQL training in Pune</a>iteducationcentrehttps://www.blogger.com/profile/16497035013294379889noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-62652299430453728302018-09-18T23:25:43.497+05:302018-09-18T23:25:43.497+05:30Question need command
Display the difference in ...Question need command<br /><br /><br />Display the difference in joining date of employee Ashish and shreyasShinde Kalpeshhttps://www.blogger.com/profile/10769950673829831692noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-76045312431767007472018-09-18T23:24:37.464+05:302018-09-18T23:24:37.464+05:30This comment has been removed by the author.Shinde Kalpeshhttps://www.blogger.com/profile/10769950673829831692noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-9335218097049724412014-07-30T08:50:51.982+05:302014-07-30T08:50:51.982+05:30check this link for difference in seconds
http://n...check this link for difference in seconds<br />http://nimishgarg.blogspot.in/2009/12/get-dates-difference-in-days-hours.htmlNimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-23812346973795231042014-07-29T20:30:18.340+05:302014-07-29T20:30:18.340+05:30Good one to refer. When I passed with mytab as sys...Good one to refer. When I passed with mytab as sysdate-1 for dt2, I got the result as DAYS = 31<br /><br />(<br />select sysdate dt1, (sysdate-1) dt2 from dual<br />)<br /> <br />What do I need to use for getting date difference between two timestamps in seconds?Anonymousnoreply@blogger.com