Format integer date in MySQL query
Format integer date in MySQL query
mysql>SELECT FROM_UNIXTIME(1196440219);-> '2007-11-30 10:30:19' mysql>SELECT FROM_UNIXTIME(1196440219) + 0;-> 20071130103019.000000 mysql>SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(),->'%Y %D %M %h:%i:%s %x');-> '2007 30th November 10:30:59 2007'

Post a Comment