Portable general timestamp format, not 2038-limited

[Roger Miller]

On Jun 22, 10:33 am, James Harris <james.harri... at googlemail.com>
wrote:
> I have a requirement to store timestamps in a database. Simple enough
> you might think but finding a suitably general format is not easy.
> ...
> Any thoughts on a better way to do this? (Please reply-all. Thanks).
>
> --
> James


My rule of thumb in situations like this is "When in doubt store it as
text".  The one format I am pretty sure we will still be able to deal
with in 2039.

- Roger