JavaTimeInstances

doobie.postgres.JavaTimeInstances

Instances for JSR-310 date time types.

Implementation is based on https://jdbc.postgresql.org/documentation/head/java8-date-time.html, using native support for Postgres JDBC driver.

Attributes

Source
JavaTimeInstances.scala
Graph
Supertypes
class Object
trait Matchable
class Any
Known subtypes
object implicits.type

Members list

Grouped members

Constructors

object Advanced

Module of constructors for "advanced" JDBC types.

Module of constructors for "advanced" JDBC types.

Attributes

Inherited from:
MetaConstructors
Source
meta.scala
Supertypes
class Object
trait Matchable
class Any
object Basic

Module of constructors for "basic" JDBC types.

Module of constructors for "basic" JDBC types.

Attributes

Inherited from:
MetaConstructors
Source
meta.scala
Supertypes
class Object
trait Matchable
class Any

Implicits

Implicits

implicit val JavaTimeInstantMeta: Meta[Instant]

This type should map to TIMESTAMP WITH TIMEZONE (TIMESTAMPTZ)

This type should map to TIMESTAMP WITH TIMEZONE (TIMESTAMPTZ)

Attributes

Source
JavaTimeInstances.scala
implicit val JavaTimeLocalDateMeta: Meta[LocalDate]

This type should map to DATE

This type should map to DATE

Attributes

Source
JavaTimeInstances.scala
implicit val JavaTimeLocalDateTimeMeta: Meta[LocalDateTime]

This type should map to TIMESTAMP

This type should map to TIMESTAMP

Attributes

Source
JavaTimeInstances.scala
implicit val JavaTimeLocalTimeMeta: Meta[LocalTime]

This type should map to TIME

This type should map to TIME

Attributes

Source
JavaTimeInstances.scala
implicit val JavaTimeOffsetDateTimeMeta: Meta[OffsetDateTime]

This type should map to TIMESTAMP WITH TIMEZONE (TIMESTAMPTZ) When writing to the database, the same instant is preserved if your target column is of type TIMESTAMPTZ (The JDBC driver works out the timezone conversion for you). Note that since offset information is not stored in the database column, retrieving the same value will yield the same instant in time, but with offset = 0 (UTC)

This type should map to TIMESTAMP WITH TIMEZONE (TIMESTAMPTZ) When writing to the database, the same instant is preserved if your target column is of type TIMESTAMPTZ (The JDBC driver works out the timezone conversion for you). Note that since offset information is not stored in the database column, retrieving the same value will yield the same instant in time, but with offset = 0 (UTC)

Attributes

Source
JavaTimeInstances.scala
implicit val JavaTimeOffsetTimeMeta: Meta[OffsetTime]

This type should map to TIME WITH TIMEZONE (TIMETZ)

This type should map to TIME WITH TIMEZONE (TIMETZ)

Attributes

Source
JavaTimeInstances.scala