change time format inside of query

[kh99]

OK, then how about this:

PHP Code:

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