db2 CURRENT TIMESTAMP function

ionutz · #1 (**permalink**) 04-21-04, 03:33

Am I allowed to use the following:
...
DECLARE X TIMESTAMP;
SET X=CURRENT TIMESTAMP;
....
in a stored procedure in db2 udb 8.1?

sathyaram_s · #2 (**permalink**) 04-21-04, 05:48

Not too sure about the syntax, but in principle, you can store the value of current timestamp in a variable in SPs

HTH

Sathyaram

Quote:

Originally posted by ionutz
Am I allowed to use the following:
...
DECLARE X TIMESTAMP;
SET X=CURRENT TIMESTAMP;
....
in a stored procedure in db2 udb 8.1?

Internet Services

Web Development

Digital Marketing

Consumer Tech