-----------------------------------------------------------------------
On Wed, 16 Feb 2000, Thomas Lockhart wrote:
> I've just committed changes to "reunify" the date/time types.
> "timestamp" and "interval" are now the two primary date/time types for
> users. Also, I've changed the default date style to "ISO" (not just in
> time for Y2K, but we'll be ready for "Y3K").
>
> Also, I made some changes to have NUMERIC be a "known" type for
> purposes of implicit type coersion, but have not tested to see if the
> underlying conversion functions are available.
>
> initdb required (and enforced by a catalog version change).
>
> Regression tests pass, except for the rules test due to ongoing rules
> formatting work.
Great, you fix my formatting code for timestamp. Thanks Thomas!
But conversion timestam to 'tm' struct is not Y2038 ready
(POSIX 'tm' limitation?):
test=# select to_char('Fri Feb 18 11:57:47 2038 CET'::timestamp, 'HH:MI:SS YYYY'); to_char
---------------10:57:47 2038
(1 row)
Or simple:
test=# select 'Fri Feb 18 11:57:47 2038 CET'::timestamp; ?column?
--------------------------Thu Feb 18 10:57:47 2038
(1 row)
Or am I something leave out?
Karel