Is there a way to do operations on the special register - current timestamp? The goal is to be able to use it as a criteria in a where clause . for e.g. lets say i have a table with createtimestamp as a column. In Oracle, I can fetch records created in the past 1 hour with a where clause of "createtimestamp > (sysdate - 1/24)" or for the past 1 day as "createtimestamp > (sysdate - 1)". In Db2, my understanding was that current timestamp was the equivalent of sysdate but I am not able to get operations such as subtraction to work on it.

Select * from table_name
where createtimestamp + 1 hour > current timestamp

You should find this and many more datetime functions and operators you can use with current date in SQL Reference



HTH

Sathyaram