Loading...
 
Features / Usability

Features / Usability


Re: Re: "Since last visit new" module question

posts: 214

The MySQL column is stored in timestamp format, the number of seconds since 00:00:00 UTC January 1, 1970.

1392216349 is Wed, 12 Feb 2014 14:45:49 UTC.

You can get it converted to a more readable date using SQL:
SELECT FROM_UNIXTIME(`lastLogin`) FROM `users_users` WHERE `login` = '(your user name)';

Or, I found this webpage where you can enter the timestamp and it will convert it for you: http://www.onlineconversion.com/unix_time.htm

Tom

There are no comments at this time.