Reputation: 2783
I try to write a function with an input like ( IN myDate DateTime)
but i run into "DATETIME" ist ein nicht definierter Name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.69.56
How can i fix it?
Upvotes: 0
Views: 638
Reputation: 601
If you want TIMESTAMP
input parameter, you should declare it as such. See an example:
$ db2 "create or replace procedure timestamp_to_month(in ts timestamp)
language sql
return month(date(ts))"
$ db2 "call timestamp_to_month(current timestamp)"
Return Status = 9
$ db2 "call timestamp_to_month(timestamp('2019-01-01'))"
Return Status = 1
Upvotes: 2