Date/Time data type and representation in graphs
Plot your data in seconds (MsSQL, MySQL, PostgreSQL, SQLite, CSV)
Brought to you by:
dbplot
Menu
▾
▴
Hi,
I'm new to dbplot and fiddled around a while and my most needs are pretty much satisfied, so thank you for this nice piece of software!
What keeps me pointless is date/time format. I use a SQlite database where the date/time is saved as string formatted as "yyyy-mm-dd hh:mm:ss" (without quotes). If I select this column as x-axis there are 2 two things which go wrong IMHO:
1) the date/time data is not used as a "value" --> which results in equidistant "points" - even if the date/time entries are not equidistant (I use point as chart type); this wa y i don't get a real graphical reflection of my "timed" parameters
2) when I use the mouse to move around the chart area --> the x-values represented underneath the chart are some sort of RowID representation, but not a date/time-value
Any hint about that is much appreciated
Thanx
Ralf
Ralf,
Thanks for your info. I did know about this issue but I have not got chance to fix it.
Pete