[fdo-trac] #226: SDF Defect when filtering on date
FDO
trac_fdo at osgeo.org
Fri Jan 18 08:24:30 EST 2008
#226: SDF Defect when filtering on date
----------------------------+-----------------------------------------------
Reporter: bscott | Owner: gregboone
Type: defect | Status: new
Priority: major | Milestone: 3.3.0
Component: SDF Provider | Version: 3.2.0
Severity: 2 | Keywords:
External_id: |
----------------------------+-----------------------------------------------
only this date filter works
MYDATE = TIMESTAMP '2007-01-01 00:00:00'
All these one return wrong results
MYDATE = DATE '2007-01-01'
MYDATE > DATE '2007-01-01'
MYDATE < DATE '2007-01-01'
MYDATE >= DATE '2007-01-01'
MYDATE <= DATE '2007-01-01'
MYDATE > DATE TIMESTAMP '2007-01-01 00:00:00'
MYDATE < DATE TIMESTAMP '2007-01-01 00:00:00'
MYDATE >= DATE TIMESTAMP '2007-01-01 00:00:00'
MYDATE <= DATE TIMESTAMP '2007-01-01 00:00:00'
--
Ticket URL: <http://trac.osgeo.org/fdo/ticket/226>
FDO <http://fdo.osgeo.org/>
Feature Data Objects
More information about the fdo-trac
mailing list