We build. You grow.
Get best community software hereStart a social network, a fan-site, an education project with oxwall - free opensource community software
last_activityStamp | Forum
+---------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+------------------+------+-----+---------+----------------+
| activityStamp | int(11) | NO | | 0 | |
+---------------+------------------+------+-----+---------+----------------+
regards
I too would like to know what how to reformat the activity stamp stored in in the ow_base_user table back to a date, not using the application (at this stage) as have been asked to provide a report of recent activity for users.Gotta love Google - found the answer to my question. I used the function FROM_UNIXTIME(activityStamp)
+---------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------+------------------+------+-----+---------+----------------+
| activityStamp | int(11) | NO | | 0 | |
+---------------+------------------+------+-----+---------+----------------+
regards
