5 replies to this topic

[newphpcoder]

Hi

I got an error:

Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), NOW()),' day(s) ', TIMESTAMPDIFF(HOUR, AVG(chemicalweighing_dateEntry), NOW()' at line 1
(0 ms taken)

from my query:

SELECT (concat(TIMESTAMPDIFF(DAY, AVG(), NOW()),' day(s) ', TIMESTAMPDIFF(HOUR, AVG(chemicalweighing_dateEntry), NOW()) - (TIMESTAMPDIFF(DAY, AVG(chemicalweighing_dateEntry), NOW()) * 24), ' hr(s) ago')) AS AGE FROM kanban_data GROUP BY chemicalweighing_dateEntry;

I just need to get the aging.


Thank you.

Attached Thumbnails

• 

[wim DC]

It probably doesn't like you calculating the average of nothing:

[LEFT][COLOR=#333333]DAY, [B]AVG()[/B], NOW()[/COLOR][/LEFT]

[newphpcoder]

So what should be my code?

Thank you

[WingedPanther73]

It depends on what you want to take the average of.

[newphpcoder]

I revised my code to this:

SELECT (concat(TIMESTAMPDIFF(DAY, AVG(chemicalweighing_dateEntry), NOW()),' day(s) ', TIMESTAMPDIFF(HOUR, AVG(chemicalweighing_dateEntry), NOW()) - (TIMESTAMPDIFF(DAY, AVG(chemicalweighing_dateEntry), NOW()) * 24), ' hr(s) ago')) AS AGE FROM kanban_data GROUP BY chemicalweighing_dateEntry;

and i also try instead of AVG I use MAX

SELECT (concat(TIMESTAMPDIFF(DAY, MAX(chemicalweighing_dateEntry), NOW()),' day(s) ', TIMESTAMPDIFF(HOUR, MAX(chemicalweighing_dateEntry), NOW()) - (TIMESTAMPDIFF(DAY, MAX(chemicalweighing_dateEntry), NOW()) * 24), ' hr(s) ago')) AS AGE FROM kanban_data GROUP BY chemicalweighing_dateEntry;

and they are same output.

and I attach the result.

Now I want to know how can I can the sum of ALL this data.


I need a query again to get the sum or I need output is : 67 day(s) 200 hr(s) ago.

Thank you so much

Attached Thumbnails

• 

[newphpcoder]

I tried this:

SELECT(concat(SUM(TIMESTAMPDIFF(DAY, chemicalweighing_dateEntry, NOW())),' day(s) '), SUM(TIMESTAMPDIFF(HOUR, chemicalweighing_dateEntry, NOW()) - (TIMESTAMPDIFF(DAY, chemicalweighing_dateEntry, NOW()) * 24), ' hr(s) ago')) AS AGE FROM kanban_data;

and I got an error:

Error Code : 1241
Operand should contain 1 column(s)
(0 ms taken)


I can't figured out where I am wrong
Thank you