Module org.postgresql.pljava
Package org.postgresql.pljava.adt

Interface Datetime

public interface Datetime
Container for abstract-type functional interfaces in PostgreSQL's DATETIME type category.

  • Nested Class Summary

    Nested Classes
    Modifier and Type
    Interface
    Description
    static interface 
    Datetime.Date<T>
    The DATE type's PostgreSQL semantics: a signed number of days since the "Postgres epoch".
    static interface 
    Datetime.Time<T>
    The TIME type's PostgreSQL semantics: microseconds since midnight.
    static interface 
    Datetime.Timestamp<T>
    The TIMESTAMP type's PostgreSQL semantics: microseconds since midnight of the PostgreSQL epoch, without an assumed time zone.
    static interface 
    Datetime.TimestampTZ<T>
    The TIMESTAMPTZ type's PostgreSQL semantics: microseconds since midnight UTC of the PostgreSQL epoch.
    static interface 
    Datetime.TimeTZ<T>
    The TIMETZ type's PostgreSQL semantics: microseconds since midnight, accompanied by a time zone offset expressed in seconds.

  • Field Summary

    Fields
    Modifier and Type
    Field
    Description
    static final int
    DATEVAL_NOBEGIN
    PostgreSQL "infinitely early" date, as a value of what would otherwise be days from the PostgreSQL epoch.
    static final int
    DATEVAL_NOEND
    PostgreSQL "infinitely late" date, as a value of what would otherwise be days from the PostgreSQL epoch.
    static final long
    DT_NOBEGIN
    PostgreSQL "infinitely early" timestamp, as a value of what would otherwise be microseconds from the PostgreSQL epoch.
    static final long
    DT_NOEND
    PostgreSQL "infinitely late" timestamp, as a value of what would otherwise be microseconds from the PostgreSQL epoch.
    static final int
    MAX_TIME_PRECISION
    Maximum value allowed for a type modifier specifying the seconds digits to the right of the decimal point for a TIME or TIMETZ.
    static final int
    MAX_TIMESTAMP_PRECISION
    Maximum value allowed for a type modifier specifying the seconds digits to the right of the decimal point for a TIMESTAMP or TIMESTAMPTZ.
    static final int
    POSTGRES_EPOCH_JDATE
    The PostgreSQL "epoch", 1 January 2000, as a Julian day; the date represented by a DATE, TIMESTAMP, or TIMESTAMPTZ with a stored value of zero.
    static final long
    USECS_PER_DAY
    The maximum allowed value, inclusive, for a TIME or the time portion of a TIMETZ.

  • Field Details

    • DATEVAL_NOBEGIN

      static final int DATEVAL_NOBEGIN
      PostgreSQL "infinitely early" date, as a value of what would otherwise be days from the PostgreSQL epoch.
      See Also:

    • DATEVAL_NOEND

      static final int DATEVAL_NOEND
      PostgreSQL "infinitely late" date, as a value of what would otherwise be days from the PostgreSQL epoch.
      See Also:

    • DT_NOBEGIN

      static final long DT_NOBEGIN
      PostgreSQL "infinitely early" timestamp, as a value of what would otherwise be microseconds from the PostgreSQL epoch.
      See Also:

    • DT_NOEND

      static final long DT_NOEND
      PostgreSQL "infinitely late" timestamp, as a value of what would otherwise be microseconds from the PostgreSQL epoch.
      See Also:

    • POSTGRES_EPOCH_JDATE

      static final int POSTGRES_EPOCH_JDATE
      The PostgreSQL "epoch", 1 January 2000, as a Julian day; the date represented by a DATE, TIMESTAMP, or TIMESTAMPTZ with a stored value of zero.
      See Also:

    • MAX_TIME_PRECISION

      static final int MAX_TIME_PRECISION
      Maximum value allowed for a type modifier specifying the seconds digits to the right of the decimal point for a TIME or TIMETZ.
      See Also:

    • MAX_TIMESTAMP_PRECISION

      static final int MAX_TIMESTAMP_PRECISION
      Maximum value allowed for a type modifier specifying the seconds digits to the right of the decimal point for a TIMESTAMP or TIMESTAMPTZ.
      See Also:

    • USECS_PER_DAY

      static final long USECS_PER_DAY
      The maximum allowed value, inclusive, for a TIME or the time portion of a TIMETZ.

      The limit is inclusive; PostgreSQL officially accepts 24:00:00 as a valid time value.

      See Also: