I don't see any reason why that shouldn't work but you should use DATEDIFF() to subtract two dates:
Code:
SELECT username, NOW(), date_registered, DATEDIFF(NOW(), date_registered) AS diff FROM users
MySQL AB :: MySQL 5.0 Reference Manual :: 10.6 Date and Time Functions