[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