docs/api/exposed-kotlin-datetime/org.jetbrains.exposed.v1.datetime/index.html
TypesFunctions
Link copied to clipboard
object CurrentDate : Function<LocalDate>
Represents an SQL function that returns the current date, as LocalDate.
Link copied to clipboard
object CurrentDateTime : CurrentTimestampBase<LocalDateTime>
Represents an SQL function that returns the current date and time, as LocalDateTime.
Link copied to clipboard
object CurrentTimestamp : CurrentTimestampBase<Instant>
Represents an SQL function that returns the current date and time, as kotlin.time.Instant.
Link copied to clipboard
sealed class CurrentTimestampBase<T> : Function<T>
Represents the base SQL function that returns the current date and time, as determined by the specified columnType.
Link copied to clipboard
object CurrentTimestampWithTimeZone : CurrentTimestampBase<OffsetDateTime>
Represents an SQL function that returns the current date and time with time zone, as OffsetDateTime.
Link copied to clipboard
class KotlinDurationColumnType : DurationColumnType<Duration>
Column for storing time-based amounts of time, as Duration.
Link copied to clipboard
class KotlinInstantColumnType : InstantColumnType<Instant>
Column for storing dates and times without time zone, as kotlin.time.Instant.
Link copied to clipboard
class KotlinLocalDateColumnType : LocalDateColumnType<LocalDate>
Column for storing dates, as LocalDate.
Link copied to clipboard
class KotlinLocalDateTimeColumnType : LocalDateTimeColumnType<LocalDateTime>
Column for storing dates and times without time zone, as LocalDateTime.
Link copied to clipboard
class KotlinLocalTimeColumnType : LocalTimeColumnType<LocalTime>
Column for storing times, as LocalTime.
KotlinOffsetDateTimeColumnType
Link copied to clipboard
class KotlinOffsetDateTimeColumnType : OffsetDateTimeColumnType<OffsetDateTime>
Column for storing dates and times with time zone, as OffsetDateTime.
Link copied to clipboard
object XCurrentTimestamp : CurrentTimestampBase<Instant>
Represents an SQL function that returns the current date and time, as kotlinx.datetime.Instant.
Link copied to clipboard
class XKotlinInstantColumnType : InstantColumnType<Instant>
Column for storing dates and times without time zone, as kotlinx.datetime.Instant.
Link copied to clipboard
class YearInternal(val expr: Expression<*>) : Function<Int>
Link copied to clipboard
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.
Link copied to clipboard
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.
Link copied to clipboard
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.
Link copied to clipboard
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.
Link copied to clipboard
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
Link copied to clipboard
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.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeDateFunction")
fun <T : OffsetDateTime?> Date(expr: Expression<T>): Function<LocalDate>
Represents an SQL function that extracts the date part from a given timestampWithTimeZone expr.
@JvmName(name = "InstantDateFunction")
fun <T : Instant?> Date(expr: Expression<T>): Function<LocalDate>
@JvmName(name = "XInstantDateFunction")
fun <T : Instant?> Date(expr: Expression<T>): Function<LocalDate>
Represents an SQL function that extracts the date part from a given timestamp expr.
@JvmName(name = "LocalDateDateFunction")
fun <T : LocalDate?> Date(expr: Expression<T>): Function<LocalDate>
Represents an SQL function that extracts the date part from a given expr.
@JvmName(name = "LocalDateTimeDateFunction")
fun <T : LocalDateTime?> Date(expr: Expression<T>): Function<LocalDate>
Represents an SQL function that extracts the date part from a given datetime expr.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeDateExt")
fun <T : OffsetDateTime?> Expression<T>.date(): Function<LocalDate>
Returns the date from this timestampWithTimeZone expression.
@JvmName(name = "XInstantDateExt")
fun <T : Instant?> Expression<T>.date(): Function<LocalDate>
@JvmName(name = "InstantDateExt")
fun <T : Instant?> Expression<T>.date(): Function<LocalDate>
Returns the date from this timestamp expression.
@JvmName(name = "LocalDateDateExt")
fun <T : LocalDate?> Expression<T>.date(): Function<LocalDate>
Returns the date from this date expression.
@JvmName(name = "LocalDateTimeDateExt")
fun <T : LocalDateTime?> Expression<T>.date(): Function<LocalDate>
Returns the date from this datetime expression.
fun Table.date(name: String): Column<LocalDate>
A date column to store a date.
Link copied to clipboard
fun dateLiteral(value: LocalDate): LiteralOp<LocalDate>
Returns the specified value as a date literal.
Link copied to clipboard
fun dateParam(value: LocalDate): Expression<LocalDate>
Returns the specified value as a date query parameter.
Link copied to clipboard
fun Table.datetime(name: String): Column<LocalDateTime>
A datetime column to store both a date and a time without time zone.
Link copied to clipboard
fun dateTimeLiteral(value: LocalDateTime): LiteralOp<LocalDateTime>
Returns the specified value as a date with time literal.
Link copied to clipboard
fun dateTimeParam(value: LocalDateTime): Expression<LocalDateTime>
Returns the specified value as a date with time query parameter.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeDayFunction")
fun <T : OffsetDateTime?> Day(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the day field from a given timestampWithTimeZone expr.
@JvmName(name = "InstantDayFunction")
fun <T : Instant?> Day(expr: Expression<T>): Function<Int>
@JvmName(name = "XInstantDayFunction")
fun <T : Instant?> Day(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the day field from a given timestamp expr.
@JvmName(name = "LocalDateDayFunction")
fun <T : LocalDate?> Day(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the day field from a given date expr.
@JvmName(name = "LocalDateTimeDayFunction")
fun <T : LocalDateTime?> Day(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the day field from a given datetime expr.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeDayExt")
fun <T : OffsetDateTime?> Expression<T>.day(): Function<Int>
Returns the day from this timestampWithTimeZone expression, as an integer between 1 and 31 inclusive.
@JvmName(name = "InstantDayExt")
fun <T : Instant?> Expression<T>.day(): Function<Int>
@JvmName(name = "XInstantDayExt")
fun <T : Instant?> Expression<T>.day(): Function<Int>
Returns the day from this timestamp expression, as an integer between 1 and 31 inclusive.
@JvmName(name = "LocalDateDayExt")
fun <T : LocalDate?> Expression<T>.day(): Function<Int>
Returns the day from this date expression, as an integer between 1 and 31 inclusive.
@JvmName(name = "LocalDateTimeDayExt")
fun <T : LocalDateTime?> Expression<T>.day(): Function<Int>
Returns the day from this datetime expression, as an integer between 1 and 31 inclusive.
Link copied to clipboard
fun Table.duration(name: String): Column<Duration>
A date column to store a duration.
Link copied to clipboard
fun durationLiteral(value: Duration): LiteralOp<Duration>
Returns the specified value as a duration literal.
Link copied to clipboard
fun durationParam(value: Duration): Expression<Duration>
Returns the specified value as a duration query parameter.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeHourFunction")
fun <T : OffsetDateTime?> Hour(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the hour field from a given timestampWithTimeZone expr.
@JvmName(name = "InstantHourFunction")
fun <T : Instant?> Hour(expr: Expression<T>): Function<Int>
@JvmName(name = "XInstantHourFunction")
fun <T : Instant?> Hour(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the hour field from a given timestamp expr.
@JvmName(name = "LocalDateHourFunction")
fun <T : LocalDate?> Hour(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the hour field from a given date expr.
@JvmName(name = "LocalDateTimeHourFunction")
fun <T : LocalDateTime?> Hour(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the hour field from a given datetime expr.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeHourExt")
fun <T : OffsetDateTime?> Expression<T>.hour(): Function<Int>
Returns the hour from this timestampWithTimeZone expression, as an integer between 0 and 23 inclusive.
@JvmName(name = "InstantHourExt")
fun <T : Instant?> Expression<T>.hour(): Function<Int>
@JvmName(name = "XInstantHourExt")
fun <T : Instant?> Expression<T>.hour(): Function<Int>
Returns the hour from this timestamp expression, as an integer between 0 and 23 inclusive.
@JvmName(name = "LocalDateHourExt")
fun <T : LocalDate?> Expression<T>.hour(): Function<Int>
Returns the hour from this date expression, as an integer between 0 and 23 inclusive.
@JvmName(name = "LocalDateTimeHourExt")
fun <T : LocalDateTime?> Expression<T>.hour(): Function<Int>
Returns the hour from this datetime expression, as an integer between 0 and 23 inclusive.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeMinuteFunction")
fun <T : OffsetDateTime?> Minute(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the minute field from a given timestampWithTimeZone expr.
@JvmName(name = "InstantMinuteFunction")
fun <T : Instant?> Minute(expr: Expression<T>): Function<Int>
@JvmName(name = "XInstantMinuteFunction")
fun <T : Instant?> Minute(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the minute field from a given timestamp expr.
@JvmName(name = "LocalDateMinuteFunction")
fun <T : LocalDate?> Minute(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the minute field from a given date expr.
@JvmName(name = "LocalDateTimeMinuteFunction")
fun <T : LocalDateTime?> Minute(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the minute field from a given datetime expr.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeMinuteExt")
fun <T : OffsetDateTime?> Expression<T>.minute(): Function<Int>
Returns the minute from this timestampWithTimeZone expression, as an integer between 0 and 59 inclusive.
@JvmName(name = "InstantMinuteExt")
fun <T : Instant?> Expression<T>.minute(): Function<Int>
@JvmName(name = "XInstantMinuteExt")
fun <T : Instant?> Expression<T>.minute(): Function<Int>
Returns the minute from this timestamp expression, as an integer between 0 and 59 inclusive.
@JvmName(name = "LocalDateMinuteExt")
fun <T : LocalDate?> Expression<T>.minute(): Function<Int>
Returns the minute from this date expression, as an integer between 0 and 59 inclusive.
@JvmName(name = "LocalDateTimeMinuteExt")
fun <T : LocalDateTime?> Expression<T>.minute(): Function<Int>
Returns the minute from this datetime expression, as an integer between 0 and 59 inclusive.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeMonthFunction")
fun <T : OffsetDateTime?> Month(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the month field from a given timestampWithTimeZone expr.
@JvmName(name = "InstantMonthFunction")
fun <T : Instant?> Month(expr: Expression<T>): Function<Int>
@JvmName(name = "XInstantMonthFunction")
fun <T : Instant?> Month(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the month field from a given timestamp expr.
@JvmName(name = "LocalDateMonthFunction")
fun <T : LocalDate?> Month(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the month field from a given date expr.
@JvmName(name = "LocalDateTimeMonthFunction")
fun <T : LocalDateTime?> Month(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the month field from a given datetime expr.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeMonthExt")
fun <T : OffsetDateTime?> Expression<T>.month(): Function<Int>
Returns the month from this timestampWithTimeZone expression, as an integer between 1 and 12 inclusive.
@JvmName(name = "XInstantMonthExt")
fun <T : Instant?> Expression<T>.month(): Function<Int>
@JvmName(name = "InstantMonthExt")
fun <T : Instant?> Expression<T>.month(): Function<Int>
Returns the month from this timestamp expression, as an integer between 1 and 12 inclusive.
@JvmName(name = "LocalDateMonthExt")
fun <T : LocalDate?> Expression<T>.month(): Function<Int>
Returns the month from this date expression, as an integer between 1 and 12 inclusive.
@JvmName(name = "LocalDateTimeMonthExt")
fun <T : LocalDateTime?> Expression<T>.month(): Function<Int>
Returns the month from this datetime expression, as an integer between 1 and 12 inclusive.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeSecondFunction")
fun <T : OffsetDateTime?> Second(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the second field from a given timestampWithTimeZone expr.
@JvmName(name = "InstantSecondFunction")
fun <T : Instant?> Second(expr: Expression<T>): Function<Int>
@JvmName(name = "XInstantSecondFunction")
fun <T : Instant?> Second(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the second field from a given timestamp expr.
@JvmName(name = "LocalDateSecondFunction")
fun <T : LocalDate?> Second(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the second field from a given date expr.
@JvmName(name = "LocalDateTimeSecondFunction")
fun <T : LocalDateTime?> Second(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the second field from a given datetime expr.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeSecondExt")
fun <T : OffsetDateTime?> Expression<T>.second(): Function<Int>
Returns the second from this timestampWithTimeZone expression, as an integer between 0 and 59 inclusive.
@JvmName(name = "XInstantSecondExt")
fun <T : Instant?> Expression<T>.second(): Function<Int>
@JvmName(name = "InstantSecondExt")
fun <T : Instant?> Expression<T>.second(): Function<Int>
Returns the second from this timestamp expression, as an integer between 0 and 59 inclusive.
@JvmName(name = "LocalDateSecondExt")
fun <T : LocalDate?> Expression<T>.second(): Function<Int>
Returns the second from this date expression, as an integer between 0 and 59 inclusive.
@JvmName(name = "LocalDateTimeSecondExt")
fun <T : LocalDateTime?> Expression<T>.second(): Function<Int>
Returns the second from this datetime expression, as an integer between 0 and 59 inclusive.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeTimeFunction")
fun <T : OffsetDateTime?> Time(expr: Expression<T>): Function<LocalTime>
Represents an SQL function that extracts the time part from a given timestampWithTimeZone expr.
@JvmName(name = "InstantTimeFunction")
fun <T : Instant?> Time(expr: Expression<T>): Function<LocalTime>
@JvmName(name = "XInstantTimeFunction")
fun <T : Instant?> Time(expr: Expression<T>): Function<LocalTime>
Represents an SQL function that extracts the time part from a given timestamp expr.
@JvmName(name = "LocalDateTimeFunction")
fun <T : LocalDate?> Time(expr: Expression<T>): Function<LocalTime>
Represents an SQL function that extracts the time part from a given date expr.
@JvmName(name = "LocalDateTimeTimeFunction")
fun <T : LocalDateTime?> Time(expr: Expression<T>): Function<LocalTime>
Represents an SQL function that extracts the time part from a given datetime expr.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeTimeExt")
fun <T : OffsetDateTime?> Expression<T>.time(): Function<LocalTime>
Returns the time from this timestampWithTimeZone expression.
@JvmName(name = "InstantTimeExt")
fun <T : Instant?> Expression<T>.time(): Function<LocalTime>
@JvmName(name = "XInstantTimeExt")
fun <T : Instant?> Expression<T>.time(): Function<LocalTime>
Returns the time from this timestamp expression.
@JvmName(name = "LocalDateTimeExt")
fun <T : LocalDate?> Expression<T>.time(): Function<LocalTime>
Returns the time from this date expression.
@JvmName(name = "LocalDateTimeTimeExt")
fun <T : LocalDateTime?> Expression<T>.time(): Function<LocalTime>
Returns the time from this datetime expression.
fun Table.time(name: String): Column<LocalTime>
A time column to store a time.
Link copied to clipboard
fun timeLiteral(value: LocalTime): LiteralOp<LocalTime>
Returns the specified value as a time literal.
Link copied to clipboard
fun timeParam(value: LocalTime): Expression<LocalTime>
Returns the specified value as a time query parameter.
Link copied to clipboard
fun Table.timestamp(name: String): Column<Instant>
A timestamp column to store both a date and a time without time zone.
Link copied to clipboard
fun timestampLiteral(value: Instant): LiteralOp<Instant>
fun timestampLiteral(value: Instant): LiteralOp<Instant>
Returns the specified value as a timestamp literal.
Link copied to clipboard
fun timestampParam(value: Instant): Expression<Instant>
fun timestampParam(value: Instant): Expression<Instant>
Returns the specified value as a timestamp query parameter.
Link copied to clipboard
fun Table.timestampWithTimeZone(name: String): Column<OffsetDateTime>
A timestamp column to store both a date and a time with time zone.
Link copied to clipboard
fun timestampWithTimeZoneLiteral(value: OffsetDateTime): LiteralOp<OffsetDateTime>
Returns the specified value as a date with time and time zone literal.
Link copied to clipboard
fun timestampWithTimeZoneParam(value: OffsetDateTime): Expression<OffsetDateTime>
Returns the specified value as a date with time and time zone query parameter.
Link copied to clipboard
fun XCustomTimeStampFunction(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.
Link copied to clipboard
fun Table.xTimestamp(name: String): Column<Instant>
A timestamp column to store both a date and a time without time zone.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeYearFunction")
fun <T : OffsetDateTime?> Year(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the year field from a given timestampWithTimeZone expr.
@JvmName(name = "InstantYearFunction")
fun <T : Instant?> Year(expr: Expression<T>): Function<Int>
@JvmName(name = "XInstantYearFunction")
fun <T : Instant?> Year(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the year field from a given timestamp expr.
@JvmName(name = "LocalDateYearFunction")
fun <T : LocalDate?> Year(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the year field from a given date expr.
@JvmName(name = "LocalDateTimeYearFunction")
fun <T : LocalDateTime?> Year(expr: Expression<T>): Function<Int>
Represents an SQL function that extracts the year field from a given datetime expr.
Link copied to clipboard
@JvmName(name = "OffsetDateTimeYearExt")
fun <T : OffsetDateTime?> Expression<T>.year(): Function<Int>
Returns the year from this timestampWithTimeZone expression, as an integer.
@JvmName(name = "InstantYearExt")
fun <T : Instant?> Expression<T>.year(): Function<Int>
@JvmName(name = "XInstantYearExt")
fun <T : Instant?> Expression<T>.year(): Function<Int>
Returns the year from this timestamp expression, as an integer.
@JvmName(name = "LocalDateYearExt")
fun <T : LocalDate?> Expression<T>.year(): Function<Int>
Returns the year from this date expression, as an integer.
@JvmName(name = "LocalDateTimeYearExt")
fun <T : LocalDateTime?> Expression<T>.year(): Function<Int>
Returns the year from this datetime expression, as an integer.
Generated by Dokka © 2026 Copyright