I have the following table with 4 rows only:
When i run the query
select * from TABLE9
where dateLastChanged < dateLastUploaded
on this table, i expect to see the rows 1 & 4, however i get this:
When i run
select * from TABLE9
where dateLastChanged > dateLastUploaded
i get
, and to
select * from TABLE9
where dateLastChanged <> dateLastUploaded
i get all 4 of it. ... where dateLastChanged = dateLastUploaded gets none.
I tried casting to timestamp-- got the same results:
select * from TABLE9
where timestamp(dateLastChanged) < timestamp(dateLastUploaded)
Whats missing???
my first time with DB2 on a prj. increasingly "loving" it.
Note: I'm aware that i can get around this on the Java side.
//--------------------------
EDIT:
clarifying what i thought was clear in the Q:
How come
select * from TABLE9
where dateLastChanged < dateLastUploaded
is returning dateLastChanged < dateLastUploaded, dateLastChanged > dateLastUploaded and dateLastChanged = dateLastUploaded.
How does DB2 decide which timestamp is greater, smaller, equal, not equal to one another. the timestamps for row tNumber=bbbbb were created and written at the same time.
//--------------------
EDIT-2
In my original Q - "greater-than/less-than" in the comparison of the timestamps is confused. This (the latter timestamp is greater/not) is easy enough to figure once i get passed the inconsistency i laid out in the Q and the edit right before this.
