Opened 7 years ago

Closed 7 years ago

Last modified 7 years 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 7 years ago.
Preliminary patch implementing datetime support.

Download all attachments as: .zip

Change History (4)

by warmerdam, 7 years ago

Attachment: date_patch.diff​ added

Preliminary patch implementing datetime support.

comment:1 by warmerdam, 7 years ago

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 by Even Rouault, 7 years ago

Resolution: → fixed
Status: new → closed

In 37398:

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

comment:3 by Even Rouault, 7 years ago

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.