Details
Minor Description
Create a timestamp table and insert a timestamp
create table timestamp_table (ts timestamp primary key)upsert into timestamp_table values ('1995-05-02 01:01:01')
Example test case
select ts + 1 from timestamp_table
Expected result:
The timestamp with one day added to it
1995-05-03 01:01:01
Actual result:
the unmodified timestamp