"But there's no way my code will be running unchanged in 2038!"

I wonder about storing the timestamp in a varchar field of sufficient size to avoid all of these headaches? Although I guess 64 bit will suffice for a very long time.

As a point of reference, the universe is estimated at less than 2^59 seconds old.

man 3p time suggests using time_t to "ease the eventual fix".