Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.
create function drdata.mmddyy(mydate decimal(6,0)) returns DATE language sql return CAST(left('20' || right(mydate,2) || '-' || right('0' || trim(mydate),6),2) || '-' || substr(right('0' || trim(mydate),6),3,2) as DATE); ;
SQL State: 22007
Vendor Code: -180
Message: [SQL0180] Syntax of date, time, or timestamp value not valid. Cause . . . . . : The string representation of a date, time, or timestamp value does not conform to the syntax for the specified or implied data type and format. SQL_RETURN.SQLF_OUTPUT is either the character string constant that is not valid or the column or host variable that contained the string. If the name is *N, then the value is an expression specified in the statement. If the string was found in a host variable, the host variable number is 1. Recovery . . . : Ensure that the date, time, or timestamp value conforms to the syntax for the data type it represents. Try the request again.
|db2 how to connect to remote database from my||3||339|
|Help needed: db2 rollforward db issues with SQL1273N and SQL1276N Unable to complete rollforwarding||3||1,210|
|Date and Time Conversion from Numeric Fields||21||276|
|SQL400 max size||5||92|