Home » SQL & PL/SQL » SQL & PL/SQL » Subtract two dates to get years,months and days (Oracle 8.1.7)
Subtract two dates to get years,months and days [message #276145] Wed, 24 October 2007 02:06 Go to next message
kumarvk
Messages: 211
Registered: July 2004
Senior Member
hi experts,

I have two dates from which I want to get the years,months and days. Any sql is available can anyone help me?
Re: Subtract two dates to get years,months and days [message #276156 is a reply to message #276145] Wed, 24 October 2007 03:01 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes there is a SQL available and it is for example in this site, just search it.

Regards
Michel
Previous Topic: Distinct jobs
Next Topic: Viewing the old and new value in the local area of a trigger
Goto Forum:
  


Current Time: Sun Dec 04 12:28:28 CST 2016

Total time taken to generate the page: 0.07197 seconds