Re: Using Epoch to save timestamps in 4 bytes?

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Francisco Reyes <lists(at)stringsutils(dot)com> writes:
> Given that all of our dates will fall within what we can store in 4bytes, 
> what would be the easiest way to use epoch as a timestamp?

Well, if you're bound and determined to create a Y2038 problem for
yourself, you could use the legacy "abstime" datatype.

Actually, that choice will blow up on you rather sooner than 2038,
since I'm sure we'll pull abstime from the system well before it
actually starts failing to represent now().  But future-proofing
doesn't seem to be part of your design goals, so you might as well
use it while it's there.

			regards, tom lane