assuming you don't care about leap years, use the MOD function. On Tue, Jan 6, 2009 at 7:11 AM, Scott <scottbar...@msn.com> wrote:
> > Need to create a script to calculate following and display in a unique > format (Oracle 10g, PL/SQL): > > (Date 1) - (Date 2) > Example: (1/31/2009) - (2/1/2004) which would equal 1826 days > > I need to convert the 1826 days value to the following format: > > 5 years, 0 days > > Any ideas on how to do this? > > thanks > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
