... AS SecondsElapsed
FROM StaffActivities s
WHERE WEEKDAY(s.DateTimeCreated)=0
AND YEARWEEK(s.DateTimeCreated)=YEARWEEK(NOW()) - $w_value
AND s.StaffUserID='STRING_TO_REPLACE_PER_ITERATION'
) ...
Why?
I recently made a joomla module that displays the lastest members to signup. It goes a little further and counts activated accounts for the past day, week, month and year (the below examples count ...
... - TIME_TO_SEC(s.DateTimeCreated)))/26640) AS PersonDays,
CONCAT(r.CapexCode, ' - ', r.ResourceName) AS Resource,
s.StaffActivity AS Activity,
s.AdditionalNotes AS Notes,
CONCAT(SUBSTRING(YEARWEEK(s.DateTimeCreated,1) ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.