What a Unix timestamp is
A Unix timestamp is the number of seconds (or milliseconds) since 1970-01-01 UTC. Programs and databases use it because it's just a number — easy to compare and compute. But no human reads 1718000000 as a date, so you convert to and from ordinary dates.