Export last login value

[Tanguy]

Hi,
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

[tuxedo-rb]

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

EDIT:
Example query:

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

[Tanguy]

@tuxedo-rb

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

Thx for your reply have good day