[TYPO3-mvc] How to compare a DateTime object correctly inanExtbase query?

[Lienhart Woitok]

Hi Jan,

> ... And the database column is "datetime", too.

And that is probably your problem. TYPO3 and Extbase store DateTime as Timestamp in the database (using an integer column). Having a datetime column is not supported (at least by Extbase) as the comparison is made using a timestamp. Try to convert your column to timestamps and it should work.

Regards,

Lienhart Woitok
Web-Entwickler | netlogix Media

Telefon: +49 (911) 539909 - 0
E-Mail: Lienhart.Woitok at netlogix.de
Web: media.netlogix.de




netlogix GmbH & Co. KG
IT-Services | IT-Training | Media
Neuwieder Straße 10 | 90411 Nürnberg
Telefon: +49 (911) 539909 - 0 | Fax: +49 (911) 539909 - 99
E-Mail: info at netlogix.de | Web: http://www.netlogix.de

netlogix GmbH & Co. KG ist eingetragen am Amtsgericht Nürnberg (HRA 13338)
Persönlich haftende Gesellschafterin: netlogix Verwaltungs GmbH (HRB 20634)
Umsatzsteuer-Identifikationsnummer: DE 233472254
Geschäftsführer: Stefan Buchta, Matthias Schmidt