mapping interval to duration

[Roland M.]

Hello,

how can I mapp an interval (hour to minute) to java.time.duration from a result set?

So, I have a column with data type  INTERVAL HOUR (3) TO MINUTE.

And now I want to mapp it into java.time.Duration when the ResultSet is processed

Something like:

ResultSet results = createStatement().executeQuery(SELECT overtime FROM table_x)

Duration x = results.get <- what I have to do here.

Duration x = (Duration) results.getObject(1) throws

org.h2.api.Interval cannot be cast to java.time.Duration

Thank yu for your help.

Roland

[Evgenij Ryazanov]

Hello.

You need to use

getObject(1, Duration.class);

[Roland M.]

Thank you very much for your quick response.

That is easy (if you know how :-))