|
|
Joined: Jun 2001
Posts: 176
Member
|
Member
Joined: Jun 2001
Posts: 176 |
if I do this SELECT U_Laston FROM w3t_Users WHERE U_Username= 'dslam' it will return "1055589726" well this is not readable to me so is there a way to convert this?
|
|
|
|
Joined: Nov 2001
Posts: 10,369
I type Like navaho
|
I type Like navaho
Joined: Nov 2001
Posts: 10,369 |
it's the number of seconds since Epoch time... (Jan 1 1970). I wrote a little script to convert it and vice versa here. I also have it installled here: http://www.joshuapettit.com/time.php
|
|
|
|
Joined: Jun 2001
Posts: 176
Member
|
Member
Joined: Jun 2001
Posts: 176 |
should have know you wrote something thanks this is useful
|
|
|
|
Joined: May 1999
Posts: 1,715
Addict
|
Addict
Joined: May 1999
Posts: 1,715 |
You could also write the query like this to get the date and time directly:
SELECT FROM_UNIXTIME(U_Laston) FROM w3t_Users WHERE U_Username= 'dslam'
|
|
|
|
Joined: Aug 2002
Posts: 1,191
Kahuna
|
Kahuna
Joined: Aug 2002
Posts: 1,191 |
And add to that the DATE_FORMAT(FROM_UNIXTIME(U_Laston), blah) to format the date on the SQL query. More help on the parameters that the DATE_FORMAT takes can be found here.
Nikos
|
|
|
|
Joined: Jun 2001
Posts: 176
Member
|
Member
Joined: Jun 2001
Posts: 176 |
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 1,157
Joined: July 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|