# Oracle TIMESTAMP Data Types

**URL:** <https://community.dremio.com/t/oracle-timestamp-data-types/2740>\
**Category:** Uncategorized\
**Created:** [February 8, 2019, 5:15pm UTC](https://community.dremio.com/t/oracle-timestamp-data-types/2740 "2019-02-08T17:15:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mchogithub](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/mchogithub/32/1295_2.png) [@mchogithub](https://community.dremio.com/u/mchogithub)\
**Post date:** [February 8, 2019, 5:15pm UTC](https://community.dremio.com/t/oracle-timestamp-data-types/2740/1 "2019-02-08T17:15:08Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [February 10, 2019, 11:21pm UTC](https://community.dremio.com/t/oracle-timestamp-data-types/2740/2 "2019-02-10T23:21:17Z")

</div>

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”}

 ![Dremio-to-timestamp](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/9/92754bf2a8165b2d35f4606dfa911dfe7705c3e1.png)

---

<div class="post-metadata">

**Author:** ![mchogithub](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/mchogithub/32/1295_2.png) [@mchogithub](https://community.dremio.com/u/mchogithub)\
**Post date:** [February 11, 2019, 12:16am UTC](https://community.dremio.com/t/oracle-timestamp-data-types/2740/3 "2019-02-11T00:16:11Z")

</div>

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