Opened 14 years ago

Closed 14 years ago

#226 closed defect (fixed)

SDF Defect when filtering on date

Reported by: bscott Owned by: gregboone
Priority: major Milestone: 3.3.0
Component: SDF Provider Version: 3.2.0
Severity: 2 Keywords:
Cc: External ID:

Description

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'

Change History (3)

comment:1 Changed 14 years ago by gregboone

Owner: changed from gregboone to badreddinekaroui

comment:2 Changed 14 years ago by gregboone

Owner: changed from badreddinekaroui to gregboone
Status: newassigned

comment:3 Changed 14 years ago by gregboone

Resolution: fixed
Status: assignedclosed
Note: See TracTickets for help on using tickets.