The PostgreSQL documentation claims that the range of an 'interval'#
Thu Dec 18 17:33:51 2003
Topics:
The PostgreSQL documentation claims that the range of an 'interval' type is +/- 178000000 years. So why do I get this?
stargreen=> select interval '3280756607 second' ;
interval
---------------------
24855 days 03:14:07
(1 row)
Does that answer look familiar? It should
CL-USER> (+ (* 3 3600) (* 14 60) 7 (* 86400 24855)) 2147483647
So, there must be some other way to make Postgres convert from CL universal time to its own time format
stargreen=> select timestamp with time zone '1901-01-01 0:0:0' + interval '3280756607 second' ;
?column?
------------------------
1969-01-19 04:14:07+01
(1 row)
because the obvious solution isn't one.