[Impact123]

PHP Code:

SELECT DATE_FORMAT(FROM_UNIXTIME(connect_time), "%Y-%m-%m") 


Same result as connect_date, let the database do the work.