Title: selecting system date / time

Howdy:

Connecting to DB2 OS/390 6.1.2.

How can I select the system date/time and populate that
data into a mock column?  For example, in Oracle, I
can do something like:

[snip]
SQL> select sysdate as today from dual;

TODAY
-------------------
2003-11-04 12:07:16

[/snip]

where 'sysdate' is the timestamp returned from
the system.  How can I do this with DB2?

Thanks!

-X

Reply via email to