UserStatus plugin:Howto change lastlogindate data value into date time format


I would like to know how to change data of lastlogindate and lastlogoffdate into date time format in UserStatus Plugin.


Anyone knows how?

The time is stored in the Unix time. This is stored in milliseconds since 1.1.1970.

If you are using Excel to convert the time 1295481626136 into a date you may use:

=DATEVALUE(“1/1/1970”)+A1/1000/60/60/24 (the cell A1 should store the UNIX time value)

You get 20/1/2011 0:00 (if you format the cell as date time)

If I want to set a query in SQL, how sould the time format be?