# Not a date?

**URL:** <https://forum.cloverdx.com/t/not-a-date/99>\
**Category:** CloverDX Platform\
**Created:** [July 16, 2007, 12:00am UTC](https://forum.cloverdx.com/t/not-a-date/99 "2007-07-16T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![oldforum](https://avatars.discourse-cdn.com/v4/letter/o/13edae/32.png) [@oldforum](https://forum.cloverdx.com/u/oldforum)\
**Post date:** [July 16, 2007, 12:00am UTC](https://forum.cloverdx.com/t/not-a-date/99/1 "2007-07-16T00:00:00Z")

</div>

Hi,

I have run into this exception, on a DBInputTable component :

java.lang.RuntimeException: not a Date : 2007-04-18 08:00:00+02 in record # 0 in field # 0 when parsing record #98 field ddt\_arr\_anest\_room  
at org.jetel.connection.SQLDataParser.populateField(SQLDataParser.java:188)  
at org.jetel.connection.SQLDataParser.parseNext(SQLDataParser.java:163)  
at org.jetel.connection.SQLDataParser.getNext(SQLDataParser.java:94)  
at org.jetel.component.DBInputTable.execute(DBInputTable.java:171)  
at org.jetel.graph.Node.run(Node.java:364)  
at java.lang.Thread.run(Thread.java:619)

Well, 2007-04-18 08:00:00+02 obviously IS a date (a timestamp with time zone to be exact).  
Any idea what this exception means ?

Franck

---

<div class="post-metadata">

**Author:** ![oldforum](https://avatars.discourse-cdn.com/v4/letter/o/13edae/32.png) [@oldforum](https://forum.cloverdx.com/u/oldforum)\
**Post date:** [July 16, 2007, 8:23am UTC](https://forum.cloverdx.com/t/not-a-date/99/2 "2007-07-16T08:23:44Z")

</div>

Hmm, strange.

I assume the field is defined as DATE/DATETIME on DB side. It might be a problem with TIMESTAMP type.

You might temporarily solve it by specifying the corresponding field on Clover side as string and then in some reformat component convert it to date.

Could you let us know more details about the problem - db version, clover version, the graph - ideally through [http://bug.clovergui.net/](http://bug.clovergui.net/)

David.