Module org.postgresql.pljava

Package org.postgresql.pljava.adt

Interface Datetime.Timestamp<T>

All Superinterfaces:

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

All Known Implementing Classes:

Datetime.Timestamp.AsLocalDateTime

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.Timestamp<T>
extends Adapter.Contract.Scalar<T>

The TIMESTAMP type's PostgreSQL semantics: microseconds since midnight of the PostgreSQL epoch, without an assumed time zone.

Nested Class Summary

Nested Classes

Modifier and Type	Interface	Description
static class	Datetime.Timestamp.AsLocalDateTime	A reference implementation that maps to LocalDateTime.
static interface	Datetime.Timestamp.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 LocalDateTime	POSTGRES_EPOCH	The PostgreSQL "epoch" as a java.time.LocalDateTime.

Method Summary

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

Field Details

POSTGRES_EPOCH

static final LocalDateTime POSTGRES_EPOCH

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

Method Details

construct

T construct(long microsecondsSincePostgresEpoch)

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

The argument represents microseconds since midnight on POSTGRES_EPOCH.

Because no particular time zone is understood to apply, the exact corresponding point on a standard timeline cannot be identified, absent outside information. It is typically used to represent a timestamp in the local zone, whatever that is.

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.