[ryanveach]

I am fairly new to DB2. I was wondering if somebody can tell me if there is a way to get the system date from DB2.
For example, in Oracle
SQL> select sysdate from dual;
SYSDATE
---------
17-DEC-01

where dual is just a dummy table. It can be any table_name.

Thanks

[Osias Correa]

You can try this one

db2 select current date from sysibm.sysdummy1

sysibm.sysdummy is the "Oracke dual" for DB2.

[ryanveach]

That's exactly what I wanted. Thanks.
Actually I wanted more info like time etc..
So,
select current timestamp from sysibm.sysdummy1
worked better for me.

[sathyaram_s]

easier is to use

values(current timestamp)

Cheers

Sathyaram

Originally posted by ryanveach
That's exactly what I wanted. Thanks.
Actually I wanted more info like time etc..
So,
select current timestamp from sysibm.sysdummy1
worked better for me.

[sramesh]

Can you tell me more about this in-memory table sysibm.sysdummy1.
?