T
Thiru Malai
Guest
I have written a query to show character as decimal value but i got an error. Let me share
DEFINE VARIABLE cDateTime AS CHARACTER NO-UNDO.
DEFINE TEMP-TABLE tt_data NO-UNDO
FIELD DateTime AS DECIMAL FORMAT "->>,>>9.99".
ASSIGN
cDateTime = "20191604121566".
CREATE tt_data.
ASSIGN
tt_data.DateTime = DECIMAL(cDateTime) /* Message Date and Time */
But its says "Value cannot be displayed using ->>>,>>>,>>9.999999". Could you please help this case and tell me what is the wrong here?
Continue reading...
DEFINE VARIABLE cDateTime AS CHARACTER NO-UNDO.
DEFINE TEMP-TABLE tt_data NO-UNDO
FIELD DateTime AS DECIMAL FORMAT "->>,>>9.99".
ASSIGN
cDateTime = "20191604121566".
CREATE tt_data.
ASSIGN
tt_data.DateTime = DECIMAL(cDateTime) /* Message Date and Time */
But its says "Value cannot be displayed using ->>>,>>>,>>9.999999". Could you please help this case and tell me what is the wrong here?
Continue reading...