Try this:
select current_timestamp - '2002-12-05 22:14'::timestamp;
Dave Cramer wrote:
> Joseph,
>
> Can you send me a test case to demonstrate what you are trying to do?
>
> Dave
> On Thu, 2002-12-05 at 21:45, Joseph Shraibman wrote:
>
>>If I try to get an interval from postgres via jdbc I get:
>>
>>No class found for interval
>> at
>>org.postgresql.jdbc1.AbstractJdbc1Connection.getObject(AbstractJdbc1Connection.java:693)
>> at
>>org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(AbstractJdbc2Connection.java:117)
>> at
>>org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:147)
>>
>>Why can't the interval just be returned as a String?
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 5: Have you checked our extensive FAQ?
>>
>>http://www.postgresql.org/users-lounge/docs/faq.html
--
Joseph Shraibman
joseph@xtenit.com
Increase signal to noise ratio. http://xis.xtenit.com