1select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456'); 2timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456') 331622400123456 4explain extended select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456'); 5id select_type table type possible_keys key key_len ref rows filtered Extra 61 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used 7Warnings: 8Note 1003 select timestampdiff(MICROSECOND,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456') AS `timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456')` 9create view v1 as select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456'); 10select * from v1; 11Name_exp_1 1231622400123456 13drop view v1; 14