@Rkg Grg 'last_ddltime' gets updated everytime a table is modified. How are you replacing the data file of the table ? I have always used LOAD DATA to replace the data from a new file and it updates last_ddltime on every occassion. LOAD DATA [LOCAL] INPATH '/pathToNewFile' OVERWRITE INTO TABLE tablename; Converting unixtime to timestamp select cast(from_unixtime(1483631785) AS timestamp); ... View more