How to get DATETIME of the row inserted into Table

Question

I need to display number of users created from last login to current login in my ELGG application, but there is no field in the ElggUser to record the date & time of users created (ElggUser Table Structure).

So is there any way to get DATETIME of rows already inserted into Table?

Thank You

Answer 1

Database schema of Elgg does contain this information. ElggUser extends ElggEntity that has attributes time_created, time_updated, last_action containing Unix timestamps representation of entity creation/modification/last action by this entity or on related content.

These attributes are stored in {DB_PREFIX}entities table and are availible as properties of all ElggEntity subclasses.