# Dremio adds 'TIMESTAMP' word when connects to Oracle DB **URL:** \ **Category:** Uncategorized\ **Created:** [November 29, 2023, 9:37am UTC](https://community.dremio.com/t/dremio-adds-timestamp-word-when-connects-to-oracle-db/11215 "2023-11-29T09:37:22Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Anton](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@Anton](https://community.dremio.com/u/Anton)\ **Post date:** [November 29, 2023, 9:37am UTC](https://community.dremio.com/t/dremio-adds-timestamp-word-when-connects-to-oracle-db/11215/1 "2023-11-29T09:37:22Z")
Greetings. It seems that there is some glitch between Dremio and Oracle. I use the following Dremio query to Oracle: ```auto SELECT * FROM "DWH Standby"."ODS_073"."T_AIR_LEGS" WHERE deleted_flag = 'N' AND active_flag = 'Y' AND part_date = CAST(DATE_TRUNC('DAY', 2023-01-01) AS DATE) ``` I get this in Oracle: ```auto FROM "ODS_073"."T_AIR_LEGS" WHERE "T_AIR_LEGS"."DELETED_FLAG" = 'N' AND "T_AIR_LEGS"."ACTIVE_FLAG" = 'Y' AND "T_AIR_LEGS"."PART_DATE" = **TIMESTAMP**'2023-01-01 00:00:00.000' ``` The Oracle DB administrator says that the string **“PART\_DATE” = TIMESTAMP ‘2023-01-01 00:00:00.000’** is incorrect and instead there should be string like this **“PART\_DATE” = ‘2023-01-01 00:00:00.000’** (without TIMESTAMP word). It seems that somehow Dremio sending the query to Oracle adding the word TIMESTAMP silently. I make some debug to understand how much resources and how much time consumes this query. Here is what I have when I execute the query with TIMESTAMP in Oracle: ![изображение](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/4/4a442e9e591e08c9509de708d6513174f74deb1c.png) **A lot!** Is there some way for Dremio to send the queries into Oracle DB without TIMESTAMP ? ---
**Author:** ![Anton](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@Anton](https://community.dremio.com/u/Anton)\ **Post date:** [November 29, 2023, 9:38am UTC](https://community.dremio.com/t/dremio-adds-timestamp-word-when-connects-to-oracle-db/11215/2 "2023-11-29T09:38:21Z")
And this is the same query, but without TIMESTAMP word: ![изображение](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/9/9708ee4d72de9212f7e22ef49f0d3542aeb6d0ce.png) **Far much better!** ---
**Author:** ![dch](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/dch/32/4140_2.png) [@dch](https://community.dremio.com/u/dch)\ **Post date:** [November 29, 2023, 9:42am UTC](https://community.dremio.com/t/dremio-adds-timestamp-word-when-connects-to-oracle-db/11215/3 "2023-11-29T09:42:08Z")
What is the data type of part\_date column? ---
**Author:** ![Anton](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@Anton](https://community.dremio.com/u/Anton)\ **Post date:** [November 30, 2023, 9:23am UTC](https://community.dremio.com/t/dremio-adds-timestamp-word-when-connects-to-oracle-db/11215/4 "2023-11-30T09:23:18Z")
This is what I see about data type of PART\_DATE column in Dremio (TIMESTAMP type): ![Снимок экрана 2023-11-30 в 12.14.50](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/b/b4b001032c44098cc87f125ffaf27fb0af8615ce.png) ---
**Author:** ![Anton](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@Anton](https://community.dremio.com/u/Anton)\ **Post date:** [November 30, 2023, 9:27am UTC](https://community.dremio.com/t/dremio-adds-timestamp-word-when-connects-to-oracle-db/11215/5 "2023-11-30T09:27:04Z")
And this is what I see about data type of PART\_DATE column in Oracle (DATE type): ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/a/a76c9910a253ad9e3c0ce39887b599cae14a1afb.jpeg) ---
**Author:** ![Michael\_Flower](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/michael_flower/32/3165_2.png) [@Michael\_Flower](https://community.dremio.com/u/Michael_Flower)\ **Post date:** [November 30, 2023, 3:06pm UTC](https://community.dremio.com/t/dremio-adds-timestamp-word-when-connects-to-oracle-db/11215/6 "2023-11-30T15:06:42Z")
Please check the connection settings from Dremio to your Oracle source - perhaps the setting “Map Oracle DATE columns to TIMESTAMP” is enabled - see [Oracle | Dremio Documentation](https://docs.dremio.com/current/sonar/data-sources/databases/oracle#advanced-options) ---
**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:** [December 7, 2023, 4:13am UTC](https://community.dremio.com/t/dremio-adds-timestamp-word-when-connects-to-oracle-db/11215/7 "2023-12-07T04:13:14Z")
@Anton to add to Michael’s response, here is a screenshot ![image](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/2X/a/a96707bd679fb2baed69346b60fea313cbd9f051.png)