/** * Get the whole interval in days */ public final double getTotalDays() { return getSign() * ( nano / (24.0 * 3600.0 * 1000000000.0) + seconds / (24.0 * 3600.0) + minutes / (24.0 * 60.0) + hours / 24.0 + days); }
/** * Get the whole interval in milli-seconds */ public final double getTotalMilli() { return getSign() * ( nano / 1000000.0 + 1000.0 * seconds + 1000.0 * 60.0 * minutes + 1000.0 * 3600.0 * hours + 1000.0 * 3600.0 * 24.0 * days); }
/** * Get the whole interval in hours */ public final double getTotalHours() { return getSign() * ( nano / (3600.0 * 1000000000.0) + seconds / 3600.0 + minutes / 60.0 + hours + 24.0 * days); }
/** * Get the whole interval in nano-seconds */ public final double getTotalNano() { return getSign() * ( nano + 1000000000.0 * seconds + 1000000000.0 * 60.0 * minutes + 1000000000.0 * 3600.0 * hours + 1000000000.0 * 3600.0 * 24.0 * days); }
/** * Get the whole interval in micro-seconds */ public final double getTotalMicro() { return getSign() * ( nano / 1000.0 + 1000000.0 * seconds + 1000000.0 * 60.0 * minutes + 1000000.0 * 3600.0 * hours + 1000000.0 * 3600.0 * 24.0 * days); }
/** * Get the whole interval in days */ public final double getTotalDays() { return getSign() * ( nano / (24.0 * 3600.0 * 1000000000.0) + seconds / (24.0 * 3600.0) + minutes / (24.0 * 60.0) + hours / 24.0 + days); }
/** * Get the whole interval in minutes */ public final double getTotalMinutes() { return getSign() * ( nano / (60.0 * 1000000000.0) + seconds / 60.0 + minutes + 60.0 * hours + 60.0 * 24.0 * days); }
/** * Get the whole interval in seconds */ public final double getTotalSeconds() { return getSign() * ( nano / 1000000000.0 + seconds + 60.0 * minutes + 3600.0 * hours + 3600.0 * 24.0 * days); }
/** * Get the whole interval in milli-seconds */ public final double getTotalMilli() { return getSign() * ( nano / 1000000.0 + 1000.0 * seconds + 1000.0 * 60.0 * minutes + 1000.0 * 3600.0 * hours + 1000.0 * 3600.0 * 24.0 * days); }
/** * Get the whole interval in hours */ public final double getTotalHours() { return getSign() * ( nano / (3600.0 * 1000000000.0) + seconds / 3600.0 + minutes / 60.0 + hours + 24.0 * days); }
/** * Get the whole interval in minutes */ public final double getTotalMinutes() { return getSign() * ( nano / (60.0 * 1000000000.0) + seconds / 60.0 + minutes + 60.0 * hours + 60.0 * 24.0 * days); }
/** * Get the whole interval in seconds */ public final double getTotalSeconds() { return getSign() * ( nano / 1000000000.0 + seconds + 60.0 * minutes + 3600.0 * hours + 3600.0 * 24.0 * days); }
/** * Get the whole interval in nano-seconds */ public final double getTotalNano() { return getSign() * ( nano + 1000000000.0 * seconds + 1000000000.0 * 60.0 * minutes + 1000000000.0 * 3600.0 * hours + 1000000000.0 * 3600.0 * 24.0 * days); }
/** * Get the whole interval in micro-seconds */ public final double getTotalMicro() { return getSign() * ( nano / 1000.0 + 1000000.0 * seconds + 1000000.0 * 60.0 * minutes + 1000000.0 * 3600.0 * hours + 1000000.0 * 3600.0 * 24.0 * days); }
/** * Convert a jOOQ <code>DAY TO SECOND</code> interval to a Postgres representation */ public static Object toPGInterval(DayToSecond interval) { return on("org.postgresql.util.PGInterval").create(0, 0, interval.getSign() * interval.getDays(), interval.getSign() * interval.getHours(), interval.getSign() * interval.getMinutes(), interval.getSign() * interval.getSeconds() + interval.getSign() * interval.getNano() / 1000000000.0).get(); }
/** * Convert a jOOQ <code>DAY TO SECOND</code> interval to a Postgres representation */ public static Object toPGInterval(DayToSecond interval) { return on("org.postgresql.util.PGInterval").create(0, 0, interval.getSign() * interval.getDays(), interval.getSign() * interval.getHours(), interval.getSign() * interval.getMinutes(), interval.getSign() * interval.getSeconds() + interval.getSign() * interval.getNano() / 1000000000.0).get(); }