Opened 5 months ago

Closed 5 months ago

Last modified 5 months ago

#6810 closed defect (fixed)

OGR SQL / AttributeFilter does not support date comparisons

Reported by: warmerdam Owned by: warmerdam
Priority: normal Milestone:
Component: OGR_SF Version: unspecified
Severity: normal Keywords: sql datetime
Cc:

Description

Date comparisons with the OGR SQL expression evaluation do not actually compare datetimes properly - they just do string comparisons.

Attachments (1)

date_patch.diff (7.1 KB) - added by warmerdam 5 months ago.
Preliminary patch implementing datetime support.

Download all attachments as: .zip

Change History (4)

Changed 5 months ago by warmerdam

Attachment: date_patch.diff added

Preliminary patch implementing datetime support.

comment:1 Changed 5 months ago by warmerdam

Here a the code sprint I did a preliminary implementation but I haven't been able to run the test suite or test more widely.

comment:2 Changed 5 months ago by Even Rouault

Resolution: fixed
Status: newclosed

In 37398:

OGR SQL: add comparisons on date / datetime (patch by fwarmerdam + tests by myself, fixes #6810)

comment:3 Changed 5 months ago by Even Rouault

In 37399:

ogr_plscenes.py: adapt tests due to OGR SQL now handling datatime comparisons (refs #6810)

Note: See TracTickets for help on using tickets.