Home » SQL & PL/SQL » SQL & PL/SQL » Re: How do I convert the difference between two dates into a date format
Re: How do I convert the difference between two dates into a date format [message #18504] Fri, 01 February 2002 21:22
Milind S Deobhankar
Messages: 33
Registered: January 2002
Member
The difference of the date will give you number which can be like this 6.55666. The number indicate days between the two dates if you want absolute value then try to use trunc(date1-date2) you will get absolute value but I cannot understand why you want to display in dateformat it will never get display like this.

Report message to a moderator

Previous Topic: Are there any tools?
Next Topic: Reg-version
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Aug 07 05:35:15 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.