Search Postgresql Archives

Re: Using Epoch to save timestamps in 4 bytes?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, May 8, 2008 at 10:00 PM, Bruce Momjian <bruce@xxxxxxxxxx> wrote:
>
>  Our timestamp has a much larger range than a 4-byte time_t, docs say:
>
>         <entry>4713 BC</entry>
>         <entry>294276 AD</entry>

Which is normally great.  Doesn't it have greater precision in the
modern era or something like that?

If you compile for integer dates do they have the same range?

Also, that range is fine, unless you're tracking geological timeframes.  :)


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux