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