
February 9th, 2007, 05:05 PM
|
|
Registered User
|
|
Join Date: Feb 2007
Posts: 2
Time spent in forums: 11 m 40 sec
Reputation Power: 0
|
|
|
DB2 UDB LUW Command Line Parameter
I have the following in my procedure:
CREATE PROCEDURE x_proc ( IN from_date timestamp
, IN to_date timestamp
, IN data_center char(1)
, IN run_option int)
My db2 command line is:
db2 -t -v -z x_log "call x_proc('2007-02-09-01.00.00.000000', '2007-02-09-01.00.00.000000', 'X', 1)"
And I get the following error.
SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007
Something with the timestamp, but I haven't been able to figure it out just yet. Any thoughts? Thanks.
|