How to get time in ‘2012-10-16 00:00:00’ format from unix timestamp?

SELECT FROM_UNIXTIME(1380030402)

 

o/p

2013-09-24 19:16:42

Leave a Reply