Opened 17 years ago

Closed 17 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 by gregboone, 17 years ago

Owner: changed from gregboone to badreddinekaroui

comment:2 by gregboone, 17 years ago

Owner: changed from badreddinekaroui to gregboone
Status: new → assigned

comment:3 by gregboone, 17 years ago

Resolution: → fixed
Status: assigned → closed
Note: See TracTickets for help on using tickets.