Query Run
select cast("2022-06-09T09:28:47" as time) 2 years ago
select cast("2022-06-09T09:28:47" as timestamp) 2 years ago
select UNIX_TIMESTAMP("2022-06-09T09:28:47") 2 years ago
select UNIX_TIMESTAMP("2022-06-07T09:28:47") 2 years ago