How to get PostgreSQL range types via jdbc

Question

Is there right way to get range types?

Or parse as String, and wait for native support...

For example tsrange:

["2010-01-01 14:00:00","2010-01-01 15:00:00"]

Seth · Accepted Answer · 2017-01-09 21:04:52Z

3

You can use range functions in your query to create individual date columns.

select lower(some_range) as start, upper(some_range) as end ...

Then you can use ResultSet's getDate() method on the resulting columns.

answered Jan 9, 2017 at 21:04

Seth

4866 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1