How to read Login attribute in users table from the SQL

Posted by kettaneh on February 26, 2013 at 11:33am

Hello,

in SQL, under users table, there is one attribute for login which represent the last time user has logged in.

How can I read it.. the numbers are like 1361077222 or 1278453347

any hint ? I have been searching for this but I could know find useful result

thanks

Comments

Posted by Wellsy on February 26, 2013 at 1:37pm

Hi kettaneh,

The times are Unix timestamps. You can read them using the PHP date function ( www.php.net/date ).

For example to get the current user's last logged in time you could:

<?php
global $user;
$user = user_load($user->uid);
$login_time = $user->login;
print date('d/m/Y', $login_time);
?>

Andy Wells
Web and Drupal Development
Fluid: Drupal in Derby

Posted by kettaneh on February 26, 2013 at 1:42pm

Thanks Wellsy,
I found this URL which is doing the same function (online tool) http://www.epochconverter.com/

Thanks a gain