Module org.postgresql.pljava

Package org.postgresql.pljava.adt

Interface Datetime.TimestampTZ<T>

All Superinterfaces:

Adapter.Contract<T>, Adapter.Contract.Scalar<T>

All Known Implementing Classes:

Datetime.TimestampTZ.AsOffsetDateTime

Enclosing interface:

Datetime

Functional Interface:

This is a functional interface and can therefore be used as the assignment target for a lambda expression or method reference.

@FunctionalInterface
public static interface Datetime.TimestampTZ<T>
extends Adapter.Contract.Scalar<T>

The TIMESTAMPTZ type's PostgreSQL semantics: microseconds since midnight UTC of the PostgreSQL epoch.

Nested Class Summary

Nested Classes

Modifier and Type	Interface	Description
static class	Datetime.TimestampTZ.AsOffsetDateTime	A reference implementation that maps to OffsetDateTime.
static interface	Datetime.TimestampTZ.Modifier<T>	Functional interface to obtain information from the PostgreSQL type modifier applied to the type.

Nested classes/interfaces inherited from interface org.postgresql.pljava.Adapter.Contract

Adapter.Contract.Array<T,E,A extends Adapter<E,?>>, Adapter.Contract.Scalar<T>

Field Summary

Fields

Modifier and Type	Field	Description
static final OffsetDateTime	POSTGRES_EPOCH	The PostgreSQL "epoch" as a java.time.OffsetDateTime.

Method Summary

Modifier and Type	Method	Description
T	construct(long microsecondsSincePostgresEpochUTC)	Constructs a representation T from the components of the PostgreSQL data type.

Field Details

POSTGRES_EPOCH

static final OffsetDateTime POSTGRES_EPOCH

The PostgreSQL "epoch" as a java.time.OffsetDateTime.

Method Details

construct

T construct(long microsecondsSincePostgresEpochUTC)

Constructs a representation T from the components of the PostgreSQL data type.

The argument represents microseconds since midnight UTC on POSTGRES_EPOCH.

Given any desired local time zone, conversion to/from this value is possible if the rules for that time zone as of the represented date are available.

The argument represents microseconds since POSTGRES_EPOCH, unless it is one of the special values DT_NOBEGIN or DT_NOEND.

When constructing a representation that lacks notions of positive or negative "infinity", one option is to simply map the above special values no differently than ordinary ones, and remember the two resulting representations as the "infinite" ones. If that is done without wraparound, the resulting "-infinity" value will precede all other PostgreSQL-representable dates and the resulting "+infinity" will follow them.

The older java.util.Date cannot represent those values without wraparound; the two resulting values can still be saved as representing -infinity and +infinity, but will not have the expected ordering with respect to other values. They will both be quite far from the present.