Tag: time stamp

How to convert timestamp to date in MYSQL?

Sep 6, 2012

—

by

darshakkumar

in sql & mysql

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