# Datetime-value will not be assigned completely in a query

**URL:** <https://forum.servoy.com/t/datetime-value-will-not-be-assigned-completely-in-a-query/3652>\
**Category:** Classic Servoy\
**Created:** [February 9, 2005, 3:42pm UTC](https://forum.servoy.com/t/datetime-value-will-not-be-assigned-completely-in-a-query/3652 "2005-02-09T15:42:23Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Christoph](https://avatars.discourse-cdn.com/v4/letter/c/eb8c5e/32.png) [@Christoph](https://forum.servoy.com/u/Christoph)\
**Post date:** [February 9, 2005, 3:42pm UTC](https://forum.servoy.com/t/datetime-value-will-not-be-assigned-completely-in-a-query/3652/1 "2005-02-09T15:42:23Z")

</div>

Hello,  
when I use the function ‘getDataSetByQuery()’ I have the problem that datetime-values will not be assigned correctly/completely.

The call in the method is:

```auto
vTermine = databaseManager.getDataSetByQuery(controller.getServerName(), vQuery, new Array(abfrage_start, abfrage_ende), 1000);

```

The variable ‘abfrage\_start’ is of type date and contains: ‘Mon Feb 7 2005 8:00:00 GMT+0100 (CET)’,  
the variable ‘abfrage\_ende’ is of the same type and contains: ‘Sun Feb 13 2005 19:00:00 GMT+0100 (CET)’

The problem is that the time will not be assigned in the query.

The log file shows:

```auto
Got connection, thread=AWT-EventQueue-0used sql
SELECT [...] 
WHERE (kontakte_benutzer.datum_von >= ? AND kontakte_benutzer.datum_von <= ?)

ascquestiondata[0]= 2005-02-07 ,type: java.sql.Datequestiondata[1]= 2005-02-13 ,type: java.sql.Datequestiondata
Closed connection, thread=AWT-EventQueue-0spotlight:

```