orville-postgresql-1.0.0.0: A Haskell library for PostgreSQL
CopyrightFlipstone Technology Partners 2023
LicenseMIT
StabilityStable
Safe HaskellSafe-Inferred
LanguageHaskell2010

Orville.PostgreSQL.Expr.Time

Description

Since: 1.0.0.0

Synopsis

Documentation

now :: ValueExpression Source #

The value of the current time as returned by the PostgreSQL function now().

Since: 1.0.0.0

makeInterval :: [(IntervalArgument, ValueExpression)] -> ValueExpression Source #

Constructs a ValueExpression whose value in PostgreSQL is the result of calling make_interval with the specified time intervals passed as named arguments.

Since: 1.0.0.0

data IntervalArgument Source #

Type to represent the name of a time interval argument to the PostgreSQL make_interval function. E.G.

years

IntervalArgument provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

years :: IntervalArgument Source #

The years argument to make_interval.

Since: 1.0.0.0

months :: IntervalArgument Source #

The months argument to make_interval.

Since: 1.0.0.0

weeks :: IntervalArgument Source #

The weeks argument to make_interval.

Since: 1.0.0.0

days :: IntervalArgument Source #

The days argument to make_interval.

Since: 1.0.0.0

hours :: IntervalArgument Source #

The hours argument to make_interval.

Since: 1.0.0.0

minutes :: IntervalArgument Source #

The mins argument to make_interval.

Since: 1.0.0.0

seconds :: IntervalArgument Source #

The secs argument to make_interval.

Since: 1.0.0.0