Overview

Module epgsql_codec_datetime

• Description
• Data Types
• Function Index
• Function Details

Behaviours: epgsql_codec.

Description

Codec for time, timetz, date, timestamp, timestamptz, interval

It supports both integer and float datetime representations (see https://www.postgresql.org/docs/current/runtime-config-preset.html#GUC-INTEGER-DATETIMES). But float representation support might be eventually removed.

• https://www.postgresql.org/docs/current/static/datatype-datetime.html
• $PG$/src/backend/utils/adt/timestamp.c // timestamp, timestamptz, interval
• $PG$/src/backend/utils/adt/datetime.c // helpers
• $PG$/src/backend/utils/adt/date.c // time, timetz, date

Data Types

data()

data() = pg_date() | pg_time() | pg_datetime() | pg_interval() | pg_timetz()

pg_date()

pg_date() = {Year::-4712..294276, Month::1..12, Day::1..31}

pg_datetime()

pg_datetime() = {pg_date(), pg_time()}

pg_interval()

pg_interval() = {pg_time(), Days::integer(), Months::integer()}

pg_time()

pg_time() = {Hour::0..24, Minute::0..59, Second::0..59 | float()}

pg_timetz()

pg_timetz() = {pg_time(), UtcOffset::integer()}

Function Index

Function Details

decode/3

decode_text/3

encode/3

init/2

names/0

Overview

Generated by EDoc