change time format inside of query

[mohammad6006]

How can I change lastavtivity format and add to another table?

PHP Code:

$vbulletin->db->query_write("
                    INSERT INTO `". TABLE_PREFIX ."mba_hozor`
                    (userid, dateline, date)
                    SELECT userid, lastactivity , " .vbdate('Y-m-d', lastactivity)."
                    FROM " . TABLE_PREFIX . "user
                "); 


vbdate('Y-m-d', lastactivity) not work in query