Hi
This might be a basic question for all of u, but i need help from you guys.
here is my query
select (sum(datediff(dd,DateAdmitted, DateDischarged))/count(*)) AS Avrvg
from table1
where DateDischarged is not null
this gives me the result as 4 in the column Avrvg. but the actual result should be 4.178082191. How can I display the value after the decimal point. Please help.
Thanks In advance.
Jump to PostFrom the mysql help:
DATEDIFF() returns expr1 – expr2 expressed as a value in days from one date to the other. expr1 and expr2 are date or date-and-time expressions. Only the date parts of the values are used in the calculation.
Any update on this guys....
From the mysql help:
DATEDIFF() returns expr1 – expr2 expressed as a value in days from one date to the other. expr1 and expr2 are date or date-and-time expressions. Only the date parts of the values are used in the calculation.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.