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 по дате отправления: