exposed-java-time/org.jetbrains.exposed.sql.javatime

Package-level declarations

Types

CurrentDate

object CurrentDate : Function<LocalDate>

Represents an SQL function that returns the current date, as LocalDate.

CurrentDateTime

object CurrentDateTime : CurrentTimestampBase<LocalDateTime>

Represents an SQL function that returns the current date and time, as LocalDateTime.

CurrentTimestamp

object CurrentTimestamp : CurrentTimestampBase<Instant>

Represents an SQL function that returns the current date and time, as Instant.

CurrentTimestampBase

sealed class CurrentTimestampBase<T> : Function<T>

Represents the base SQL function that returns the current date and time, as determined by the specified columnType.

CurrentTimestampWithTimeZone

object CurrentTimestampWithTimeZone : CurrentTimestampBase<OffsetDateTime>

Represents an SQL function that returns the current date and time with time zone, as OffsetDateTime.

Date

class Date<T : Temporal?>(val expr: Expression<T>) : Function<LocalDate>

Represents an SQL function that extracts the date part from a given temporal expr.

Day

class Day<T : Temporal?>(val expr: Expression<T>) : Function<Int>

Represents an SQL function that extracts the day field from a given temporal expr.

Hour

class Hour<T : Temporal?>(val expr: Expression<T>) : Function<Int>

Represents an SQL function that extracts the hour field from a given temporal expr.

JavaDurationColumnType

class JavaDurationColumnType : ColumnType<Duration>

Column for storing time-based amounts of time, as Duration.

JavaInstantColumnType

class JavaInstantColumnType : ColumnType<Instant> , IDateColumnType

Column for storing dates and times without time zone, as Instant.

JavaLocalDateColumnType

class JavaLocalDateColumnType : ColumnType<LocalDate> , IDateColumnType

Column for storing dates, as LocalDate.

JavaLocalDateTimeColumnType

class JavaLocalDateTimeColumnType : ColumnType<LocalDateTime> , IDateColumnType

Column for storing dates and times without time zone, as LocalDateTime.

JavaLocalTimeColumnType

class JavaLocalTimeColumnType : ColumnType<LocalTime> , IDateColumnType

Column for storing times, as LocalTime.

JavaOffsetDateTimeColumnType

class JavaOffsetDateTimeColumnType : ColumnType<OffsetDateTime> , IDateColumnType

Column for storing dates and times with time zone, as OffsetDateTime.

Minute

class Minute<T : Temporal?>(val expr: Expression<T>) : Function<Int>

Represents an SQL function that extracts the minute field from a given temporal expr.

Month

class Month<T : Temporal?>(val expr: Expression<T>) : Function<Int>

Represents an SQL function that extracts the month field from a given temporal expr.

Second

class Second<T : Temporal?>(val expr: Expression<T>) : Function<Int>

Represents an SQL function that extracts the second field from a given temporal expr.

Time

class Time<T : Temporal?>(val expr: Expression<T>) : Function<LocalTime>

Represents an SQL function that extracts the time part from a given temporal expr.

Year

class Year<T : Temporal?>(val expr: Expression<T>) : Function<Int>

Represents an SQL function that extracts the year field from a given temporal expr.

Functions

CustomDateFunction

fun CustomDateFunction(functionName: String, vararg params: Expression<*>): CustomFunction<LocalDate?>

Calls a custom SQL function with the specified functionName, that returns a date only, and passing params as its arguments.

CustomDateTimeFunction

fun CustomDateTimeFunction(functionName: String, vararg params: Expression<*>): CustomFunction<LocalDateTime?>

Calls a custom SQL function with the specified functionName, that returns both a date and a time, and passing params as its arguments.

CustomDurationFunction

fun CustomDurationFunction(functionName: String, vararg params: Expression<*>): CustomFunction<Duration?>

Calls a custom SQL function with the specified functionName, that returns a duration, and passing params as its arguments.

CustomTimeFunction

fun CustomTimeFunction(functionName: String, vararg params: Expression<*>): CustomFunction<LocalTime?>

Calls a custom SQL function with the specified functionName, that returns a time only, and passing params as its arguments.

CustomTimeStampFunction

fun CustomTimeStampFunction(functionName: String, vararg params: Expression<*>): CustomFunction<Instant?>

Calls a custom SQL function with the specified functionName, that returns a timestamp, and passing params as its arguments.

CustomTimestampWithTimeZoneFunction

fun CustomTimestampWithTimeZoneFunction(functionName: String, vararg params: Expression<*>): CustomFunction<OffsetDateTime?>

Calls a custom SQL function with the specified functionName, that returns both a date and a time with time zone, and passing params as its arguments.

date

fun <T : Temporal?> Expression<T>.date(): Date<T>

Returns the date from this temporal expression.

fun Table.date(name: String): Column<LocalDate>

A date column to store a date.

dateLiteral

fun dateLiteral(value: LocalDate): LiteralOp<LocalDate>

Returns the specified value as a date literal.

dateParam

fun dateParam(value: LocalDate): Expression<LocalDate>

Returns the specified value as a date query parameter.

datetime

fun Table.datetime(name: String): Column<LocalDateTime>

A datetime column to store both a date and a time without time zone.

dateTimeLiteral

fun dateTimeLiteral(value: LocalDateTime): LiteralOp<LocalDateTime>

Returns the specified value as a date with time literal.

dateTimeParam

fun dateTimeParam(value: LocalDateTime): Expression<LocalDateTime>

Returns the specified value as a date with time query parameter.

day

fun <T : Temporal?> Expression<T>.day(): Day<T>

Returns the day from this temporal expression, as an integer between 1 and 31 inclusive.

duration

fun Table.duration(name: String): Column<Duration>

A date column to store a duration.

durationLiteral

fun durationLiteral(value: Duration): LiteralOp<Duration>

Returns the specified value as a duration literal.

durationParam

fun durationParam(value: Duration): Expression<Duration>

Returns the specified value as a duration query parameter.

hour

fun <T : Temporal?> Expression<T>.hour(): Hour<T>

Returns the hour from this temporal expression, as an integer between 0 and 23 inclusive.

minute

fun <T : Temporal?> Expression<T>.minute(): Minute<T>

Returns the minute from this temporal expression, as an integer between 0 and 59 inclusive.

month

fun <T : Temporal?> Expression<T>.month(): Month<T>

Returns the month from this temporal expression, as an integer between 1 and 12 inclusive.

second

fun <T : Temporal?> Expression<T>.second(): Second<T>

Returns the second from this temporal expression, as an integer between 0 and 59 inclusive.

time

fun <T : Temporal?> Expression<T>.time(): Time<T>

Returns the time from this temporal expression.

fun Table.time(name: String): Column<LocalTime>

A time column to store a time.

timeLiteral

fun timeLiteral(value: LocalTime): LiteralOp<LocalTime>

Returns the specified value as a time literal.

timeParam

fun timeParam(value: LocalTime): Expression<LocalTime>

Returns the specified value as a time query parameter.

timestamp

fun Table.timestamp(name: String): Column<Instant>

A timestamp column to store both a date and a time without time zone.

timestampLiteral

fun timestampLiteral(value: Instant): LiteralOp<Instant>

Returns the specified value as a timestamp literal.

timestampParam

fun timestampParam(value: Instant): Expression<Instant>

Returns the specified value as a timestamp query parameter.

timestampWithTimeZone

fun Table.timestampWithTimeZone(name: String): Column<OffsetDateTime>

A timestamp column to store both a date and a time with time zone.

timestampWithTimeZoneLiteral

fun timestampWithTimeZoneLiteral(value: OffsetDateTime): LiteralOp<OffsetDateTime>

Returns the specified value as a date with time and time zone literal.

timestampWithTimeZoneParam

fun timestampWithTimeZoneParam(value: OffsetDateTime): Expression<OffsetDateTime>

Returns the specified value as a date with time and time zone query parameter.

year

fun <T : Temporal?> Expression<T>.year(): Year<T>

Returns the year from this temporal expression, as an integer.