timestamp & graph time scale

From: santosh dwivedi <mwanaag(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: timestamp & graph time scale
Date: 2005-06-13 10:35:18
Message-ID: 20050613103518.16903.qmail@web52101.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2005-06-13 13:07:11 Re: in(...) clause and PreparedStatement
Previous Message Carl Olivier 2005-06-13 10:13:31 Re: DatabaseMetaData and Transactions