org.duckdb.DuckDBTimestamp Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of duckdb_jdbc Show documentation
A JDBC-Compliant driver for the DuckDB data management system
There is a newer version: 1.1.3
package org.duckdb;

import java.sql.Timestamp;
import java.time.ZoneOffset;
import java.time.LocalDateTime;
import java.time.OffsetDateTime;
import java.time.temporal.ChronoUnit;

public class DuckDBTimestamp {
	static 
	{
		// LocalDateTime reference of epoch
		RefLocalDateTime = 
			LocalDateTime.ofEpochSecond(0, 0, ZoneOffset.UTC);
	}

	public DuckDBTimestamp(long timeMicros) {
		this.timeMicros = timeMicros;
	}

	public DuckDBTimestamp(LocalDateTime localDateTime) {
		this.timeMicros = DuckDBTimestamp.RefLocalDateTime.until(
			localDateTime, ChronoUnit.MICROS);
	}

	public DuckDBTimestamp(OffsetDateTime offsetDateTime) {
		this.timeMicros = DuckDBTimestamp.RefLocalDateTime.until(
			offsetDateTime.withOffsetSameInstant(ZoneOffset.UTC), ChronoUnit.MICROS);
	}

	public DuckDBTimestamp(Timestamp sqlTimestamp) {
		this.timeMicros = DuckDBTimestamp.RefLocalDateTime.until(
			sqlTimestamp.toLocalDateTime(), ChronoUnit.MICROS);
	}

	final static LocalDateTime RefLocalDateTime;
	protected long timeMicros;

	public static Timestamp toSqlTimestamp(long timeMicros) {
		return Timestamp.valueOf(
			LocalDateTime.ofEpochSecond(micros2seconds(timeMicros)
				, nanosPartMicros(timeMicros), ZoneOffset.UTC));
	}

	public static Timestamp toSqlTimestampNanos(long timeNanos) {
		return Timestamp.valueOf(
			LocalDateTime.ofEpochSecond(nanos2seconds(timeNanos)
				, nanosPartNanos(timeNanos), ZoneOffset.UTC));
	}
	public static LocalDateTime toLocalDateTime(long timeMicros) {
		return LocalDateTime.ofEpochSecond(micros2seconds(timeMicros)
				, nanosPartMicros(timeMicros), ZoneOffset.UTC);
	}

	public static OffsetDateTime toOffsetDateTime(long timeMicros) {
		return OffsetDateTime.of(toLocalDateTime(timeMicros), ZoneOffset.UTC);
	}

	public Timestamp toSqlTimestamp() {
		return Timestamp.valueOf(this.toLocalDateTime());
	}

	public LocalDateTime toLocalDateTime() {
		return LocalDateTime.ofEpochSecond(micros2seconds(timeMicros)
				, nanosPartMicros(timeMicros), ZoneOffset.UTC);
	}

	public OffsetDateTime toOffsetDateTime() {
		return OffsetDateTime.of(toLocalDateTime(this.timeMicros)
				, ZoneOffset.UTC);
	}

	public static long getMicroseconds(Timestamp sqlTimestamp) {
		return DuckDBTimestamp.RefLocalDateTime.until(
				sqlTimestamp.toLocalDateTime(), ChronoUnit.MICROS);
	}

	public long getMicrosEpoch() {
		return this.timeMicros;
	}

	public String toString() {
		return this.toLocalDateTime().toString();
	}

	private static long micros2seconds(long micros) {
		if ((micros % 1000_000L) >= 0) {
			return micros / 1000_000L;
		} else {
			return (micros / 1000_000L) -1;
		}
	}

	private static int nanosPartMicros(long micros) {
		if ((micros % 1000_000L) >= 0) {
			return (int) ((micros % 1000_000L) * 1000);
		}
		else {
			return (int) ((1000_000L + (micros % 1000_000L)) * 1000);
		}
	}

	private static long nanos2seconds(long nanos) {
		if ((nanos % 1_000_000_000L) >= 0) {
			return nanos / 1_000_000_000L;
		} else {
			return (nanos / 1_000_000_000L) -1;
		}
	}

	private static int nanosPartNanos(long nanos) {
		if ((nanos % 1_000_000_000L) >= 0) {
			return (int) ((nanos % 1_000_000_000L));
		}
		else {
			return (int) ((1_000_000_000L + (nanos % 1_000_000_000L)));
		}
	}
}