ashhok.kumar

 Profile Answers by ashhok.kumar 

• Feb 27th, 2011

 

0 is correct answer for the above question.
The result is displaying as 0 only.
Please try the following query: select max(sysdate) - min(sysdate) res from dual;

simbu

• Jul 14th, 2011

 

the answer is average.............not zero

Lakshmi

• Jul 15th, 2011

 

Answer is zero only.....
try the query

Code
SELECT max(sysdate)-min(sysdate) AS date FROM dual;


 

it will give result as 0..

kishorekumar522

• Jul 19th, 2011

 

the difference of dates give u the number of days between them.

so the difference of the max(sysdate)-min(sysdate) are calculation of the same day so there is no days.
as a result its value is zero.

as_anand_kumar

 Profile Answers by as_anand_kumar 

• Aug 14th, 2011

 

Answer is zero since Max(sysdate) - Min(sysdate) would give the difference (in days) between the two dates

Code
SQL> SELECT Max(sysdate) - Min(sysdate) FROM dual;


 


MAX(SYSDATE)-MIN(SYSDATE)


-------------------------


                        0


 


SQL> 

ugander

• Sep 21st, 2011

 

0

suresh shaw

• Sep 23rd, 2011

 

max(sysdate)-min(sysdate)= 0

Ramesh hurakadli

• Oct 3rd, 2011

 

result of Max(sysdate)-Min(sysdate),it means, it shows the date which is in between last date n first date of the month according to the system information.

Kalpana Mooraka

 Profile Answers by Kalpana Mooraka 

• Oct 5th, 2011

 

SQL> select max(sysdate)-min(sysdate) from dual;

MAX(SYSDATE)-MIN(SYSDATE)
-------------------------
0

SQL>