SELECT unix_timestamp(time) FROM testdatabase.user; update testdatabase.user set time = from_unixtime(1447408792);