Adding minutes to timestamp variable

prakash.hopes · #1 (**permalink**) 12-23-09, 01:00

Hiall,

I have a timestamp variable having some timestamp information. I want to add some minutes to the time represented by the timestamp variable.
The minutes that I am adding is stored in a variable. How do achieve this in DB2...

tonkuma · #2 (**permalink**) 12-23-09, 01:26

Code:

------------------------------ Commands Entered ------------------------------
SELECT cola
     , colx
     , cola + colx minutes AS "cola + colx minutes"
  FROM (VALUES CURRENT TIMESTAMP) AS table_a(cola)
     , (VALUES 5 ) AS table_b(colx)
;
------------------------------------------------------------------------------

COLA                       COLX        cola + colx minutes       
-------------------------- ----------- --------------------------
2009-12-23-15.24.10.814000           5 2009-12-23-15.29.10.814000

  1 record(s) selected.

Please see DB2 Basics: Fun with Dates and Times

prakash.hopes · #3 (**permalink**) 12-23-09, 01:30

Thanks for the response .....

Will surely try this one now

tonkuma · #4 (**permalink**) 12-23-09, 01:44

Another example:

Code:

------------------------------ Commands Entered ------------------------------
DECLARE GLOBAL TEMPORARY TABLE a(cola TIMESTAMP, colb INTEGER, colc TIMESTAMP);
------------------------------------------------------------------------------
DB20000I  The SQL command completed successfully.

------------------------------ Commands Entered ------------------------------
BEGIN ATOMIC
DECLARE val_a, val_c TIMESTAMP;
DECLARE val_b INTEGER;
SET val_a = CURRENT TIMESTAMP;
SET val_b = 5;
SET val_c = val_a + val_b minutes;
INSERT INTO SESSION.a
VALUES (val_a, val_b, val_c);
END@
------------------------------------------------------------------------------
DB20000I  The SQL command completed successfully.

------------------------------ Commands Entered ------------------------------
SELECT * FROM SESSION.a@
------------------------------------------------------------------------------

COLA                       COLB        COLC                      
-------------------------- ----------- --------------------------
2009-12-23-15.39.26.651000           5 2009-12-23-15.44.26.651000

  1 record(s) selected.

dr_te_z · #5 (**permalink**) 12-23-09, 01:52

You mean this?

Code:

C:\>set MINUTES=5

C:\>db2 select current_timestamp as now, current_timestamp + &#37;MINUTES% minutes as near_future from sysibm.sysdummy1

NOW                        NEAR_FUTURE
-------------------------- --------------------------
2009-12-23-07.51.23.426000 2009-12-23-07.56.23.426000

Internet Services

Web Development

Digital Marketing

Consumer Tech