Tag: convert timestamp

MYSQL: SELECT DATE( FROM_UNIXTIME( `time_stamp` ) ) AS sBdat FROM users   OUTPUT: 2012-09-06