How is that 365 days?
SQL> SELECT TO_DATE ('15/02/2012', 'dd/mm/yyyy')
- TO_DATE ('01/04/2011', 'dd/mm/yyyy') days
FROM DUAL
DAYS
----------
320
1 row selected.
Looks like 320 days to me.
Mike
On Tue, May 31, 2011 at 9:45 AM, Yuvaraj Sundaresan <
[email protected]> wrote:
> Hi Friends,
> I need to print the no of days(365/366) based on my input. For example
>
> * From Date To Date Output Should Be *
> (Input 1) (Input 2)
> 01/04/2011 31/03/2012 366
> 01/04/2011 15/02/2012 365(Since the To date is falling in
> Leap year but the To date is less than 29/FEB/2012 so it should print as *
> 365*)
> 01/04/2012 31/03/2013 365
> 01/01/2012 30/07/2012 366
>
> Kindly suggest me how it can be achievable.
>
>
> Regards
> Yuvaraj
>
> --
> You received this message because you are subscribed to the Google
> Groups "Oracle PL/SQL" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/Oracle-PLSQL?hl=en
>
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
