UBB.Developers Forums UBB.threads 6 V6 Modifications V6 Mod Ideas hi modify the approveusers.php

Hi everyone

i whant the approve user to sort by the registration date, normaly no problem but when i then take the colom U_Registred its some funny numbers ?? f.eks 1014980400
normaly i would have Written
SELECT U_Username,U_Email,U_RegIP,U_Number,U_Registred
FROM w3t_Users
WHERE U_Approved = 'no'
ORDER BY U_Registred

But how do i do it now ??

SELECT U_Username,U_Email,U_RegIP,U_Number,FROM_UNIXTIME(U_Registered)