Re: timestamp & graph time scale

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: santosh dwivedi <mwanaag(at)yahoo(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: timestamp & graph time scale
Date: 2005-06-13 14:34:43
Message-ID: 19649.1118673283@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

santosh dwivedi <mwanaag(at)yahoo(dot)com> writes:
> 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

I'd suggest "EXTRACT(EPOCH FROM result_time)"

regards, tom lane

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2005-06-13 15:33:33 Re: Getting Reference cursors
Previous Message Csaba Nagy 2005-06-13 13:30:12 Re: in(...) clause and PreparedStatement