diff --git a/engine/reformulation/sql/src/main/java/it/unibz/inf/ontop/answering/reformulation/generation/dialect/impl/OracleSQLDialectAdapter.java b/engine/reformulation/sql/src/main/java/it/unibz/inf/ontop/answering/reformulation/generation/dialect/impl/OracleSQLDialectAdapter.java
index <HASH>..<HASH> 100644
--- a/engine/reformulation/sql/src/main/java/it/unibz/inf/ontop/answering/reformulation/generation/dialect/impl/OracleSQLDialectAdapter.java
+++ b/engine/reformulation/sql/src/main/java/it/unibz/inf/ontop/answering/reformulation/generation/dialect/impl/OracleSQLDialectAdapter.java
@@ -48,7 +48,7 @@ public class OracleSQLDialectAdapter extends SQL99DialectAdapter {
 		SqlDatatypes.put(Types.CHAR, "CHAR");
 		SqlDatatypes.put(Types.VARCHAR, "VARCHAR(4000)");
 		SqlDatatypes.put(Types.CLOB, "CLOB");
-		SqlDatatypes.put(Types.TIMESTAMP, "VARCHAR(4000)");
+		SqlDatatypes.put(Types.TIMESTAMP, "DATE");
 		SqlDatatypes.put(Types.INTEGER, "INTEGER");
 		SqlDatatypes.put(Types.BIGINT, "NUMBER(19)");
 		SqlDatatypes.put(Types.REAL, "NUMBER");
Change Oracle timestamp to DATE instead of VARCHAR(<I>) to maintain time information