1
Ola,
I’m doing a project where I should work with DB2
. There is a table where two columns of the type were made DECIMAL
.To be more exact follow the creation code:
[DATA_VARIAZIONE] [decimal](8, 0) NOT NULL,
[ORA_VARIAZIONE] [decimal](6, 0) NOT NULL
And what I want to do is return a column of the kind TIMESTAMP
based on these two values.
Example of values of these fields:
ORA_VARIAZIONE | DATA_VARIAZIONE|
---------------|----------------|
192416 |20180427 |
The expected result is that these values are returned as a single column of type TIMESTAMP
. That is to say
DATA_ORA_VARIAZIONE|
2018-04-27-19.24.16|