You can do a insert into (dummytab) select current date from syibm.sysdummy1. dummytab would have to have a column in it that was date as a data type. You can use sysibm.sysdummy1 to get various system type info. Get date, time, etc.
Frank Crissy
Chief Systems Engineer
Data Base Administration
The Home Depot
11953
"Johnson, Shaunn"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
com> cc:
Sent by: Subject: [DB2EUG] selecting system
date / time
[EMAIL PROTECTED]
ash.org
11/04/2003 01:26
PM
Please respond to
"Johnson, Shaunn"
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
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
