# Support ORACLE date type problems **URL:** \ **Category:** CloverDX Platform\ **Created:** [September 27, 2007, 12:00am UTC](https://forum.cloverdx.com/t/support-oracle-date-type-problems/224 "2007-09-27T00:00:00Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\ **Post date:** [September 27, 2007, 12:00am UTC](https://forum.cloverdx.com/t/support-oracle-date-type-problems/224/1 "2007-09-27T00:00:00Z")
Support ORACLE date type problems. SQL\> DESC K3; Name Type Nullable Default Comments -— --------- -------- ------- -------- C1 NUMBER(4) C2 DATE Y SQL\> DESC K4; Name Type Nullable Default Comments -— --------- -------- ------- -------- K1 NUMBER(4) K2 DATE Y SQL\> select c1,to\_char(c2,‘yyyy-mm-dd hh24:mi:ss’) from k3; C1 TO\_CHAR(C2,'YYYY-MM-DDHH24:MI: ----- ------------------------------ 1 2007-09-24 00:00:01 2 2007-09-24 12:00:00 3 2007-09-29 00:00:01 1 2007-09-24 00:56:01 2 2007-09-24 22:54:00 test.grf file context: \ test133\_DB\_OUTPUT\_TABLE\_0\_0\_\_MetaData.fmt file context: \ run test.grf after , Results have not hours minutes seconds SQL\> select k1,to\_char(k2,‘yyyy-mm-dd hh24:mi:ss’) from k4; K1 TO\_CHAR(K2,'YYYY-MM-DDHH24:MI: ----- ------------------------------ 1 2007-09-24 00:00:00 2 2007-09-24 00:00:00 3 2007-09-29 00:00:00 1 2007-09-24 00:00:00 2 2007-09-24 00:00:00 ---
**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\ **Post date:** [September 27, 2007, 7:13am UTC](https://forum.cloverdx.com/t/support-oracle-date-type-problems/224/2 "2007-09-27T07:13:10Z")
Could you pls send log from execution? ---
**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\ **Post date:** [September 28, 2007, 3:19am UTC](https://forum.cloverdx.com/t/support-oracle-date-type-problems/224/3 "2007-09-28T03:19:54Z")
2007-9-27 11:15:56 org.jetel.component.DBOutputTable$OracleAutoKeyGenerator prepareStatement WARN: Columns are null 2007-9-27 11:15:56 org.jetel.component.DBOutputTable$OracleAutoKeyGenerator prepareStatement INFO: Getting generated keys switched off ! 2007-9-27 11:15:56 org.jetel.graph.TransformationGraph init INFO: Initializing DB connection: 2007-9-27 11:15:56 org.jetel.graph.TransformationGraph init INFO: DBConnection driver[oracle.jdbc.driver.OracleDriver]:url[jdbc:oracle:thin:@192.168.1.133:1521:orcl133]:user[zking] … OK 2007-9-27 11:15:56 org.jetel.graph.TransformationGraph run INFO: Starting WatchDog thread … 2007-9-27 11:15:56 org.jetel.graph.runtime.WatchDog run INFO: Thread started. 2007-9-27 11:15:56 org.jetel.graph.runtime.WatchDog run INFO: Running on 2 CPU(s) max available memory for JVM 260160 KB 2007-9-27 11:15:56 org.jetel.graph.Phase init INFO: [Clover] Initializing phase: 0 2007-9-27 11:16:07 org.jetel.component.DBOutputTable$OracleAutoKeyGenerator prepareStatement WARN: Columns are null 2007-9-27 11:16:07 org.jetel.component.DBOutputTable$OracleAutoKeyGenerator prepareStatement INFO: Getting generated keys switched off ! 2007-9-27 11:16:07 org.jetel.graph.Phase init INFO: [Clover] phase: 0 initialized successfully. 2007-9-27 11:16:07 org.jetel.graph.runtime.WatchDog executePhase INFO: Starting up all nodes in phase [0] 2007-9-27 11:16:07 org.jetel.graph.runtime.WatchDog executePhase INFO: Sucessfully started all nodes in phase! 2007-9-27 11:16:29 org.jetel.graph.runtime.WatchDog watch INFO: Execution of phase [0] successfully finished - elapsed time(sec): 21 2007-9-27 11:16:29 org.jetel.graph.runtime.WatchDog$PrintTracking printProcessingStatus INFO: ----------------------\*\* Final tracking Log for phase [0] \*\*--------------------- 2007-9-27 11:16:29 org.jetel.graph.runtime.WatchDog$PrintTracking printProcessingStatus INFO: Time: 27/09/07 11:16:29 2007-9-27 11:16:29 org.jetel.graph.runtime.WatchDog$PrintTracking printProcessingStatus INFO: Node Status Port #Records #KB Rec/s KB/s 2007-9-27 11:16:29 org.jetel.graph.runtime.WatchDog$PrintTracking printProcessingStatus INFO: ---------------------------------------------------------------------------------- 2007-9-27 11:16:29 org.jetel.graph.runtime.WatchDog$PrintTracking printProcessingStatus INFO: DB\_OUTPUT\_TABLE\_0 FINISHED\_OK 2007-9-27 11:16:29 org.jetel.graph.runtime.WatchDog$PrintTracking printProcessingStatus INFO: %cpu:… In:0 5 0 1 0 2007-9-27 11:16:29 org.jetel.graph.runtime.WatchDog$PrintTracking printProcessingStatus INFO: DB\_INPUT\_TABLE\_0 FINISHED\_OK 2007-9-27 11:16:29 org.jetel.graph.runtime.WatchDog$PrintTracking printProcessingStatus INFO: %cpu:… Out:0 5 0 1 0 2007-9-27 11:16:29 org.jetel.graph.runtime.WatchDog$PrintTracking printProcessingStatus INFO: ---------------------------------\*\* End of Log \*\*-------------------------------- 2007-9-27 11:16:29 org.jetel.graph.runtime.WatchDog run INFO: Forcing garbage collection … 2007-9-27 11:16:34 org.jetel.graph.runtime.WatchDog printPhasesSummary INFO: -----------------------\*\* Summary of Phases execution \*\*--------------------- 2007-9-27 11:16:34 org.jetel.graph.runtime.WatchDog printPhasesSummary INFO: Phase# Finished Status RunTime(sec) MemoryAllocation(KB) 2007-9-27 11:16:34 org.jetel.graph.runtime.WatchDog printPhasesSummary INFO: 0 FINISHED\_OK 21 10506 2007-9-27 11:16:34 org.jetel.graph.runtime.WatchDog printPhasesSummary INFO: ------------------------------\*\* End of Summary \*\*--------------------------- 2007-9-27 11:16:34 org.jetel.graph.TransformationGraph run INFO: WatchDog thread finished - total execution time: 38 (sec) 2007-9-27 11:16:34 org.jetel.graph.TransformationGraph run INFO: Graph execution finished successfully ---
**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\ **Post date:** [October 1, 2007, 8:40am UTC](https://forum.cloverdx.com/t/support-oracle-date-type-problems/224/4 "2007-10-01T08:40:36Z")
Hello, it could happened with old CloverETL versions. Pls download the newest version (2.3) and try again. ---
**Author:** ![alci](https://avatars.discourse-cdn.com/v4/letter/a/f08c70/32.png) [@alci](https://forum.cloverdx.com/u/alci)\ **Post date:** [October 4, 2007, 6:49pm UTC](https://forum.cloverdx.com/t/support-oracle-date-type-problems/224/5 "2007-10-04T18:49:05Z")
Hi hwhwhw 🙂 did you solve your problem ? (I think I encounter the same one) ---
**Author:** ![hwhwhw](https://avatars.discourse-cdn.com/v4/letter/h/9d8465/32.png) [@hwhwhw](https://forum.cloverdx.com/u/hwhwhw)\ **Post date:** [October 8, 2007, 3:01am UTC](https://forum.cloverdx.com/t/support-oracle-date-type-problems/224/6 "2007-10-08T03:01:16Z")
I now use is Version 2.3,But there remains the problem. ---
**Author:** ![alci](https://avatars.discourse-cdn.com/v4/letter/a/f08c70/32.png) [@alci](https://forum.cloverdx.com/u/alci)\ **Post date:** [October 8, 2007, 10:10am UTC](https://forum.cloverdx.com/t/support-oracle-date-type-problems/224/7 "2007-10-08T10:10:08Z")
That’s also what I see here… Agata, should we open a bug report ? ---
**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\ **Post date:** [October 8, 2007, 10:31am UTC](https://forum.cloverdx.com/t/support-oracle-date-type-problems/224/8 "2007-10-08T10:31:46Z")
The time is truncated, because most of databases treats DATE type as only date; it is used TIMESTAMP type for storing date and time. I’m not sure if usage of Timestamp class couldn’t cause problems in other databases. Log it to bug tracker pls. ---
**Author:** ![alci](https://avatars.discourse-cdn.com/v4/letter/a/f08c70/32.png) [@alci](https://forum.cloverdx.com/u/alci)\ **Post date:** [October 8, 2007, 12:49pm UTC](https://forum.cloverdx.com/t/support-oracle-date-type-problems/224/9 "2007-10-08T12:49:23Z")
I have submited a bug report : [http://bugs.clovergui.net/view.php?id=194](http://bugs.clovergui.net/view.php?id=194) ---
**Author:** ![mzatopek](https://avatars.discourse-cdn.com/v4/letter/m/b5e925/32.png) [@mzatopek](https://forum.cloverdx.com/u/mzatopek)\ **Post date:** [October 9, 2007, 3:54pm UTC](https://forum.cloverdx.com/t/support-oracle-date-type-problems/224/10 "2007-10-09T15:54:34Z")
Thanks, we will try to solve this issue. Martin ---
**Author:** ![bmuller](https://avatars.discourse-cdn.com/v4/letter/b/779978/32.png) [@bmuller](https://forum.cloverdx.com/u/bmuller)\ **Post date:** [November 15, 2007, 12:38am UTC](https://forum.cloverdx.com/t/support-oracle-date-type-problems/224/11 "2007-11-15T00:38:58Z")
Bug 194 is a fairly big deal for us, as we store the date and time of the entry and modification of each object. Looking at the code, the T (datetime) data type is there but not hooked up. Is the fix for this imminent, or should I add the code myself at this point? ---
**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\ **Post date:** [November 15, 2007, 7:56am UTC](https://forum.cloverdx.com/t/support-oracle-date-type-problems/224/12 "2007-11-15T07:56:14Z")
This bug was fixed in the last release (2.3.2). If you set requested format string on metadata no lost should occur.