|Problem charting datetime [message #904363]
||Tue, 28 August 2012 10:23
| James Whitehead
Registered: August 2012
I've created an oda to query and read responses from a webservice. I can get back dates in the results. I parse these results via:
return new java.sql.Timestamp(time.parse(sourceData.get(m_currentRowId - 1).get(index - 1)).getTime())
(m_currentRowId and index point to where in my sourcedata the date is.)
This produces a list of dates such as:
29 Jan 2012 20:40
27 Jan 2012 23:01
27 Jan 2012 21:53
29 Jan 2012 14:54
28 Jan 2012 09:05
27 Jan 2012 21:47
27 Jan 2012 19:45
30 Jan 2012 17:27
29 Jan 2012 12:09
28 Jan 2012 14:11
When I chart this using date time, grouping by day, a Jan 27th bar appears twice and Jan 28th not at all. By looking at the size of the bar chart I can tell it is thinking some of the 27th Jan are the same as 28th Jan and labelling this 27th Jan. There is then another bar of the rest of 27th Jan.
When I set the column type as Date (so all the times are the same) this problem does not occur.
Any ideas to why this is happening?
Powered by FUDForum
. Page generated in 0.08624 seconds