Can someone please explain what is the purpose of the "infinity" timestamp value?
Code: Select all
dbadmin=> select TIMESTAMP 'INFINITY';
?column?
----------
infinity
(1 row)
Moderator: NorbertKrupa
Code: Select all
dbadmin=> select TIMESTAMP 'INFINITY';
?column?
----------
infinity
(1 row)
Code: Select all
dbadmin=> create table temp (col1 timestamp);
CREATE TABLE
dbadmin=> insert into temp values (TIMESTAMP 'infinity');
OUTPUT
--------
1
(1 row)
dbadmin=> insert into temp values (TIMESTAMP '-infinity');
OUTPUT
--------
1
(1 row)
dbadmin=> select col1 from temp;
col1
-----------
infinity
-infinity
(2 rows)
Code: Select all
dbadmin=> select col1 from temp where sysdate < col1;
col1
----------
infinity
(1 row)
Code: Select all
dbadmin=> select col1 from temp where col1 < sysdate;
col1
-----------
-infinity
(1 row)