Oracle TIMESTAMP Data Types


#1

We have a column with default value TO_TIMESTAMP (‘01010001’, ‘ddmmyyyy’) as Oracle data source.
Dremio displays the value: ‘0000-12-30 00:00:00.000’ instead of ‘0001-01-01 00:00:00.000’.
What’s the reason?


#2

Hi @mchogithub

Which version of Dremio are you on?

Please see screenshot and JSON output pasted below. Dremio dies return “0001-01-01 00:00:00.000”

{“EXPR$0”:“0001-01-01 00:00:00.000”}


#3

Thank you for your quick answer.

We use dremio 3.1.1

We know that with the function TO_TIMESTAMP of Dremio we can correctly format the type of data.

The problem arises when the default value is set by the Oracle data source.

At the moment we have created a conditional field:

CASE WHEN $field=‘0000-12-30 00:00: 00.000’ THEN TO_TIMESTAMP (‘01010001’, ‘ddmmyyyy’) AS $field