SELECT DATE(from_unixtime(1244084155)) AS DATE; --Output: 2009-06-03 MySQL About the author Xuan Ngo is the founder of OpenWritings.net. He currently lives in Montreal, Canada. He loves to write about programming and open source subjects.
