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.

Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting