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.
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.