# Oracle 10g Date, Servoy Datetime

**URL:** <https://forum.servoy.com/t/oracle-10g-date-servoy-datetime/3501>\
**Category:** Classic Servoy\
**Created:** [January 20, 2005, 1:34pm UTC](https://forum.servoy.com/t/oracle-10g-date-servoy-datetime/3501 "2005-01-20T13:34:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tobias](https://avatars.discourse-cdn.com/v4/letter/t/c67d28/32.png) [@tobias](https://forum.servoy.com/u/tobias)\
**Post date:** [January 20, 2005, 1:34pm UTC](https://forum.servoy.com/t/oracle-10g-date-servoy-datetime/3501/1 "2005-01-20T13:34:29Z")

</div>

Hallo,

I have a problem with oracle and datatype datetime.

In oracle I use the datatype ‘date’, in servoy I have a datetime field.

Both datatypes contain both the date and time.

But when I read, for example, the date (orale) ‘2005-10-10 11:10:10’ from the db I get the value ‘2005-10-10 00:00:00’ in servoy.

When I insert a value via servoy in the db only the date is inserted without the time.

First I thought the oracle-jdbc-driver was the problem.

I have, however, tested the problem with Kodo’s jdo implementation using the oracle-jdbc-driver, and there were no problems. This leads me to believe that servoy handles the oracle types incorrectly.

I also have the same problems when the field in Oracle is a timestamp, which is even more confusing.

Tobias Wahmhoff  
eFonds24 GmbH

Oracle 10g  
Servoy Developer  
Version R2 2.1.2-build 315  
Java version 1.4.2\_01-b06 (Windows XP)

---

<div class="post-metadata">

**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\
**Post date:** [January 28, 2005, 4:40pm UTC](https://forum.servoy.com/t/oracle-10g-date-servoy-datetime/3501/2 "2005-01-28T16:40:23Z")

</div>

that is because we are following the JDBC spec. If the database is saying Types.DATE then we do ResultSet.getDate() and that goes wrong

We now fixed it so that we always are calling getTimeStamp  
hopefully all other jdbc drivers are handling that.

---

<div class="post-metadata">

**Author:** ![michaelwirz](https://avatars.discourse-cdn.com/v4/letter/m/7ab992/32.png) [@michaelwirz](https://forum.servoy.com/u/michaelwirz)\
**Post date:** [February 1, 2005, 7:48pm UTC](https://forum.servoy.com/t/oracle-10g-date-servoy-datetime/3501/3 "2005-02-01T19:48:15Z")

</div>

Hello!

Superb. When will this fix be available? Will it be there in the next  
beta build for 2.2?

Thank you,  
Michael Wirz

eFonds24 GmbH

---

<div class="post-metadata">

**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\
**Post date:** [February 1, 2005, 8:01pm UTC](https://forum.servoy.com/t/oracle-10g-date-servoy-datetime/3501/4 "2005-02-01T20:01:30Z")

</div>

yes it’s available in 2.2rc1 that you can download through autoupdate.