Tonkuma wrote:
You don't need to upgrade to Viper 2(Is that DB2 9.x ?).
DB2 V8.2 already support that.
------------------------- Commands Entered -------------------------
connect to SAMPLE user db2admin using ********;
--------------------------------------------------------------------
Database Connection Information
Database server = DB2/NT 8.2.7
SQL authorization ID = DB2ADMIN
Local database alias = SAMPLE
A JDBC connection to the target has succeeded.
------------------------- Commands Entered -------------------------
VALUES INTEGER(CURRENT DATE);
--------------------------------------------------------------------
1
-----------
20070719
1 record(s) selected.
------------------------- Commands Entered -------------------------
VALUES (current time, integer(current time));
--------------------------------------------------------------------
1 2
-------- -----------
22:07:53 220753
1 record(s) selected.
Hi,
Viper 2 might be 9.5, its not official yet.
I think Serge means that something similar to
to_char(sysdate,'yyyymmdd') will be available in Viper 2 but instead
gave a solution that is working on v8. He had posted a thread with
upcoming Oracle (and other) like functionality in Viper 2 that will
simplify cross vendor coding and migration.
With kind regards,
Michael