Below functions can be used for x100 tables.\n\n* select TIMESTAMPDIFF(day, col1, DATE '2021-12-31') from idatex\\g\nExecuting . . .\n\n\nlqqqqqqqqqqqqqqqqqqqqqqk\nxcol1 x\ntqqqqqqqqqqqqqqqqqqqqqqu\nx 365x\nmqqqqqqqqqqqqqqqqqqqqqqj\n(1 row)\ncontinue\n*\n\nWhere col1 contains 2020-12-31 and idatex is an x100 table.