Issue Bug Closed

#63482Query constraint on a DateTime field with a DateTime argument should trigger date format

Clément MICHELET 12/01/14, 14:52 updated 12/02/25, 14:36

Description

Hi,

I have a DateTime declared like this in TCA :

'dbType' => 'datetime',
'type' => 'input',
'size' => 12,
'eval' => 'datetime,required',
'checkbox' => 0,
'default' => '0000-00-00 00:00:00'

The SQL field is a native DateTime field (created from extension_builder).
When I apply a constraint on a query with an argument, It is automatically converted to an unix timestamp. My query doesn’t works because it’s expecting a native SQL datetime value instead of a timestamp. The workaround is to apply a format ->format("Y-m-d G:i:s") on the argument. This is ok but when you have to manipulate many datetime fields or have many queries, the human error factor is increasing.

I don’t have digged enough inside the extbase query API to see if we have access to the field type at the moment when the query is build. But It could be great to see this API to take in charge the date formatting step.
I think that this change is a breaking change for all of those who already applied manually the format. It will require a setting to enable/disable this behaviour and by default , It will be disabled.

Reviews 3

History 1225

  1. Georg Ringer changed tracker Feature Bug TYPO3 Version 6.2 Is Regression 0 <span data-processor="relativetime" data-value="2014-12-16T10:30:11+00:00" > 12/16/14, 10:30 </span>

  2. Benjamin Rau commented <span data-processor="relativetime" data-value="2015-01-09T13:20:19+00:00" > 01/09/15, 13:20 </span>

    I can confirm the issue! And the workaround would make it impossible to change the dbtype later without changing all constraints..

  3. Felix Nagel commented <span data-processor="relativetime" data-value="2016-02-09T17:33:06+00:00" > 02/09/16, 17:33 </span>

    Same issue when using dbType => date in TYPO3 7.6.2

  4. Stefan Froemken commented and changed TYPO3 Version 6.2 7 Complexity medium <span data-processor="relativetime" data-value="2016-11-16T12:35:01+00:00" > 11/16/16, 12:35 </span>

    I currently have the same problem, but I don’t see any chance to solve that with 2 or 3 lines of code.

    I slightly see a possibility to change preparseComparison(). We can add $query or $source as third parameter, but IMO changing DateTime objects at that point is the wrong way.

    A better place would be resolveParameterPlaceholders(), but at that point we don’t have any information about colnames and classnames anymore. We need them to build a columnMap, which is currently not possible. To solve that we have to change many methodcalls and it seems more breaking than solving that problem.

    I can confirm this problem for TYPO3 7.6, too.

  5. Felix Nagel commented <span data-processor="relativetime" data-value="2022-09-27T11:00:44+00:00" > 09/27/22, 11:00 </span>

    Still an issue in TYPO3 11.5.16 when using dbType => date.

  6. Benjamin Franzke commented and changed status Under Review Resolved done 0 % 100 % <span data-processor="relativetime" data-value="2025-04-11T08:15:12+00:00" > 04/11/25, 08:15 </span>

    Applied in changeset commit:8d2761ad5a2deaf2ff58e7a0e60ba0cfd8c1c49b.