CurrentDate

object CurrentDate : Function<LocalDate>

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

Samples

org.jetbrains.exposed.v1.datetime.DefaultsTest.testConsistentSchemeWithFunctionAsDefaultExpression

MembersMembers & Extensions

Properties

columnType

Link copied to clipboard

open override val columnType: IColumnType<LocalDate>

Functions

date

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.

day

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.

equals

Link copied to clipboard

open operator override fun equals(other: Any?): Boolean

hashCode

Link copied to clipboard

open override fun hashCode(): Int

hour

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.

minute

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.

month

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.

second

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.

time

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.

toQueryBuilder

Link copied to clipboard

open override fun toQueryBuilder(queryBuilder: QueryBuilder)

toString

Link copied to clipboard

open override fun toString(): String

year

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.