Export last login value

In user page, we can have Last login detail,
I have to export the last login from db with sql, do you know where is the last login in DB
Best regards

check table oc_preferences (replace oc_ if you use another table prefix).

Example query:

SELECT userid, DATE_FORMAT(FROM_UNIXTIME(configvalue), '%Y-%m-%d %H:%i:%s') AS last_login FROM oc_preferences WHERE configkey = 'lastLogin';

Thx :wink: for your reply have good day