UBB.Developers Forums Community Development Programming MySQL and Server Configuration mysql time or unix time convert

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?

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

should have know you wrote something
thanks this is useful

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'

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.

thanks guy's