# Query result DateTime field conversion

**URL:** <https://discourse.laminas.dev/t/query-result-datetime-field-conversion/3437>\
**Category:** Components & MVC\
**Tags:** laminas-db\
**Created:** [August 15, 2023, 5:36am UTC](https://discourse.laminas.dev/t/query-result-datetime-field-conversion/3437 "2023-08-15T05:36:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![montypanday](https://yyz2.discourse-cdn.com/flex032/user_avatar/discourse.laminas.dev/montypanday/32/1556_2.png) [@montypanday](https://discourse.laminas.dev/u/montypanday)\
**Post date:** [August 15, 2023, 5:36am UTC](https://discourse.laminas.dev/t/query-result-datetime-field-conversion/3437/1 "2023-08-15T05:36:34Z")

</div>

Hi,

I am interested to configure laminas to read dates from database as \DateTime objects.  
I am surprised it does not do it my default. I am using oracle database.

The column type is Date type and laminas result set reads it as a string based on oracle nlm setting.

Kind regards  
Monty Panday

---

<div class="post-metadata">

**Author:** ![froschdesign](https://yyz2.discourse-cdn.com/flex032/user_avatar/discourse.laminas.dev/froschdesign/32/38_2.png) [@froschdesign](https://discourse.laminas.dev/u/froschdesign)\
**Post date:** [August 16, 2023, 4:03am UTC](https://discourse.laminas.dev/t/query-result-datetime-field-conversion/3437/2 "2023-08-16T04:03:11Z")

</div>

> [@montypanday](#):
>
> I am surprised it does not do it my default.

The problem is which `DateTime` object? `DateTime`, `DateTimeImmutable` or a custom implementation of the [`DateTimeInterface`](https://www.php.net/manual/class.datetimeinterface).

You can use a hydrator to create the desired result:

> **[Result Sets - laminas-db - Laminas Docs](https://docs.laminas.dev/laminas-db/result-set/#laminasdbresultsethydratingresultset)**
>
> Database abstraction layer, SQL abstraction, result set abstraction, and RowDataGateway and TableDataGateway implementations