Hi Michel
365 is not the difference of two dates total number of days of that year
On Tue, May 31, 2011 at 10:03 AM, Michael Moore <[email protected]>wrote:
> 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
>
--
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
