timestamp & graph time scale
| От | santosh dwivedi |
|---|---|
| Тема | timestamp & graph time scale |
| Дата | |
| Msg-id | 20050613103518.16903.qmail@web52101.mail.yahoo.com обсуждение исходный текст |
| Ответ на | in(...) clause and PreparedStatement (Sergey Pariev <egy@tnet.dp.ua>) |
| Ответы |
Re: timestamp & graph time scale
|
| Список | pgsql-jdbc |
Hi All,
This is my very basic question.
I have follwing table in database.
result_time | epoch | nodeid | light |
parent | voltage
----------------------------+-------+--------+-------+--------+---------
2004-12-09 16:44:43.501375 | 1 | | |
|
2004-12-09 16:44:43.564375 | 2 | 10 | 362 |
0 | 479
2004-12-09 16:44:43.626375 | 3 | 10 | 408 |
0 | 478
2004-12-09 16:44:43.689375 | 4 | 10 | 429 |
0 | 478
2004-12-09 16:44:43.751375 | 5 | 10 | 438 |
I need to plot the light Vs Time.
For plotiing the data I am using G2Dint java API. To
plot time on x axis I need to convert time to some
integer value (suppose I choose x-axis scale in
minute)
How can I convert Timestamp time to an integer minute.
As my database is having data over months of period,
actually I need to plot values Vs time. Is there any
Idea so that I can plot light Vs time ( and can show
date along with time). IFAIK G2Dint takes float or
integer values to plot them along x axis and y axis.
How can I show the time on X axis (with date).
Thanks for help.
Regards:
santosh dwivedi
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
В списке pgsql-jdbc по дате отправления: