Time functions

Date and time utilities from io.deephaven.time.DateTimeUtils including parsing, formatting, arithmetic, and time zones.

TypeNameSignatureDescription
CLASSDateTimeUtilsNoneFunctions for working with time.
CLASSDurationNoneA time-based amount of time, such as '34.5 seconds'. This class models a quantity or amount of...
CLASSInstantNoneAn instantaneous point on the time-line. This class models a single instantaneous point on the...
CLASSLocalDateNoneA date without a time-zone in the ISO-8601 calendar system, such as 2007-12-03. LocalDate is a...
CLASSLocalTimeNoneA time without a time-zone in the ISO-8601 calendar system, such as 10:15:30. LocalTime is an ...
CLASSPeriodNoneA date-based amount of time in the ISO-8601 calendar system, such as '2 years, 3 months and 4 da...
CLASSZonedDateTimeNoneA date-time with a time-zone in the ISO-8601 calendar system, such as 2007-12-03T10:15:30+01:00 ...
CONSTANTDAYlongOne day in nanoseconds. This is one hour of wall time and does not take into account calendar adj...
CONSTANTDAYS_PER_NANOdoubleNumber of days per nanosecond.
CONSTANTHOURlongOne hour in nanoseconds.
CONSTANTHOURS_PER_NANOdoubleNumber of hours per nanosecond.
CONSTANTMICROlongOne microsecond in nanoseconds.
CONSTANTMILLIlongOne millisecond in nanoseconds.
CONSTANTMINUTElongOne minute in nanoseconds.
CONSTANTMINUTES_PER_NANOdoubleNumber of minutes per nanosecond.
CONSTANTSECONDlongOne second in nanoseconds.
CONSTANTSECONDS_PER_NANOdoubleNumber of seconds per nanosecond.
CONSTANTWEEKlongOne week in nanoseconds. This is 7 days of wall time and does not take into account calendar adju...
CONSTANTYEARS_PER_NANO_365doubleNumber of 365 day years per nanosecond.
CONSTANTYEARS_PER_NANO_AVGdoubleNumber of average (365.2425 day) years per nanosecond.
CONSTANTYEAR_365longOne 365 day year in nanoseconds. This is 365 days of wall time and does not take into account cal...
CONSTANTYEAR_AVGlongOne average year in nanoseconds. This is 365.2425 days of wall time and does not take into accoun...
CONSTANTZERO_LENGTH_INSTANT_ARRAYInstant[]A zero length array of instants.
FUNCTIONaddCalendarvoid(BusinessCalendar)Adds a calendar to the collection.
FUNCTIONaddCalendarFromFilevoid(File)Adds a calendar to the collection from a file.
FUNCTIONaddCalendarFromFilevoid(String)Adds a calendar to the collection from a file.
FUNCTIONatMidnightInstant(Instant, ZoneId)Returns an Instant for the prior midnight in the specified time zone.
FUNCTIONatMidnightZonedDateTime(LocalDate, ZoneId)Returns a ZonedDateTime for the prior midnight in the specified time zone.
FUNCTIONatMidnightZonedDateTime(LocalDateTime, ZoneId)Returns a ZonedDateTime for the prior midnight in the specified time zone.
FUNCTIONatMidnightZonedDateTime(ZonedDateTime)Returns a ZonedDateTime for the prior midnight in the specified time zone.
FUNCTIONbusinessDatesLocalDate[](Instant, Instant)Returns the business dates in a given range.
FUNCTIONbusinessDatesLocalDate[](Instant, Instant, boolean, boolean)Returns the business dates in a given range.
FUNCTIONbusinessDatesLocalDate[](LocalDate, LocalDate)Returns the business dates in a given range.
FUNCTIONbusinessDatesLocalDate[](LocalDate, LocalDate, boolean, boolean)Returns the business dates in a given range.
FUNCTIONbusinessDatesLocalDate[](ZonedDateTime, ZonedDateTime)Returns the business dates in a given range.
FUNCTIONbusinessDatesLocalDate[](ZonedDateTime, ZonedDateTime, boolean, boolean)Returns the business dates in a given range.
FUNCTIONbusinessDatesString[](String, String)Returns the business dates in a given range.
FUNCTIONbusinessDatesString[](String, String, boolean, boolean)Returns the business dates in a given range.
FUNCTIONcalendarBusinessCalendar()Returns the default business calendar.
FUNCTIONcalendarBusinessCalendar(String)Returns a business calendar.
FUNCTIONcalendarDateLocalDate()The current date for the calendar.
FUNCTIONcalendarDatesLocalDate[](Instant, Instant)Returns the dates in a given range.
FUNCTIONcalendarDatesLocalDate[](Instant, Instant, boolean, boolean)Returns the dates in a given range.
FUNCTIONcalendarDatesLocalDate[](LocalDate, LocalDate)Returns the dates in a given range.
FUNCTIONcalendarDatesLocalDate[](LocalDate, LocalDate, boolean, boolean)Returns the dates in a given range.
FUNCTIONcalendarDatesLocalDate[](ZonedDateTime, ZonedDateTime)Returns the dates in a given range.
FUNCTIONcalendarDatesLocalDate[](ZonedDateTime, ZonedDateTime, boolean, boolean)Returns the dates in a given range.
FUNCTIONcalendarDatesString[](String, String)Returns the dates in a given range.
FUNCTIONcalendarDatesString[](String, String, boolean, boolean)Returns the dates in a given range.
FUNCTIONcalendarDayCalendarDay()Returns the CalendarDay for a date.
FUNCTIONcalendarDayCalendarDay(Instant)Returns the CalendarDay for a date.
FUNCTIONcalendarDayCalendarDay(LocalDate)Returns the CalendarDay for a date.
FUNCTIONcalendarDayCalendarDay(String)Returns the CalendarDay for a date.
FUNCTIONcalendarDayCalendarDay(ZonedDateTime)Returns the CalendarDay for a date.
FUNCTIONcalendarDayOfWeekDayOfWeek()The current day of the week for the calendar.
FUNCTIONcalendarDayOfWeekDayOfWeek(Instant)The current day of the week for the calendar.
FUNCTIONcalendarDayOfWeekDayOfWeek(LocalDate)The current day of the week for the calendar.
FUNCTIONcalendarDayOfWeekDayOfWeek(String)The current day of the week for the calendar.
FUNCTIONcalendarDayOfWeekDayOfWeek(ZonedDateTime)The current day of the week for the calendar.
FUNCTIONcalendarDayOfWeekValueint()Returns a 1-based int value of the day of the week for the calendar, where 1 is Monday and 7 is S...
FUNCTIONcalendarDayOfWeekValueint(Instant)Returns a 1-based int value of the day of the week for the calendar, where 1 is Monday and 7 is S...
FUNCTIONcalendarDayOfWeekValueint(LocalDate)Returns a 1-based int value of the day of the week for the calendar, where 1 is Monday and 7 is S...
FUNCTIONcalendarDayOfWeekValueint(String)Returns a 1-based int value of the day of the week for the calendar, where 1 is Monday and 7 is S...
FUNCTIONcalendarDayOfWeekValueint(ZonedDateTime)Returns a 1-based int value of the day of the week for the calendar, where 1 is Monday and 7 is S...
FUNCTIONcalendarNameString()Returns the name of the default business calendar.
FUNCTIONcalendarNamesString[]()Returns the names of all available calendars.
FUNCTIONcalendarTimeZoneZoneId()Gets the timezone of the calendar.
FUNCTIONcalendarsFromConfigurationList()Loads the line-separated calendar XML resources from the resource file configuration value "Cale...
FUNCTIONcurrentClockClock()Returns the clock used to compute the current time. This may be the current system clock, or it m...
FUNCTIONdayOfMonthint(Instant, ZoneId)Returns a 1-based int value of the day of the month for an Instant and specified time zone. The f...
FUNCTIONdayOfMonthint(LocalDate)Returns a 1-based int value of the day of the month for a LocalDate. The first day of the month r...
FUNCTIONdayOfMonthint(LocalDateTime)Returns a 1-based int value of the day of the month for a LocalDateTime. The first day of the mon...
FUNCTIONdayOfMonthint(ZonedDateTime)Returns a 1-based int value of the day of the month for a ZonedDateTime and specified time zone. ...
FUNCTIONdayOfWeekDayOfWeek(Instant, ZoneId)Returns the day of the week for an Instant in the specified time zone.
FUNCTIONdayOfWeekDayOfWeek(LocalDate)Returns the day of the week for a LocalDate.
FUNCTIONdayOfWeekDayOfWeek(LocalDateTime)Returns athe day of the week for a ZonedDateTime.
FUNCTIONdayOfWeekDayOfWeek(ZonedDateTime)Returns the day of the week for a ZonedDateTime in the specified time zone.
FUNCTIONdayOfWeekValueint(Instant, ZoneId)Returns a 1-based int value of the day of the week for an Instant in the specified time zone, wit...
FUNCTIONdayOfWeekValueint(LocalDate)Returns a 1-based int value of the day of the week for a LocalDate, with 1 being Monday and 7 bei...
FUNCTIONdayOfWeekValueint(LocalDateTime)Returns a 1-based int value of the day of the week for a LocalDateTime, with 1 being Monday and 7...
FUNCTIONdayOfWeekValueint(ZonedDateTime)Returns a 1-based int value of the day of the week for a ZonedDateTime in the specified time zone...
FUNCTIONdayOfYearint(Instant, ZoneId)Returns a 1-based int value of the day of the year (Julian date) for an Instant in the specified ...
FUNCTIONdayOfYearint(LocalDate)Returns a 1-based int value of the day of the year (Julian date) for a LocalDate. The first day o...
FUNCTIONdayOfYearint(LocalDateTime)Returns a 1-based int value of the day of the year (Julian date) for a LocalDateTime. The first d...
FUNCTIONdayOfYearint(ZonedDateTime)Returns a 1-based int value of the day of the year (Julian date) for a ZonedDateTime in the speci...
FUNCTIONdiffBusinessDaysdouble(Instant, Instant)Returns the amount of business time in standard business days between two times.
FUNCTIONdiffBusinessDaysdouble(ZonedDateTime, ZonedDateTime)Returns the amount of business time in standard business days between two times.
FUNCTIONdiffBusinessDurationDuration(Instant, Instant)Returns the amount of business time between two times.
FUNCTIONdiffBusinessDurationDuration(ZonedDateTime, ZonedDateTime)Returns the amount of business time between two times.
FUNCTIONdiffBusinessNanoslong(Instant, Instant)Returns the amount of business time in nanoseconds between two times.
FUNCTIONdiffBusinessNanoslong(ZonedDateTime, ZonedDateTime)Returns the amount of business time in nanoseconds between two times.
FUNCTIONdiffBusinessYearsdouble(Instant, Instant)Returns the number of business years between start and end.
FUNCTIONdiffBusinessYearsdouble(ZonedDateTime, ZonedDateTime)Returns the number of business years between start and end.
FUNCTIONdiffDaysdouble(Instant, Instant)Returns the difference in days between two instant values.
FUNCTIONdiffDaysdouble(ZonedDateTime, ZonedDateTime)Returns the difference in days between two zoned date time values.
FUNCTIONdiffMicroslong(Instant, Instant)Returns the difference in microseconds between two instant values.
FUNCTIONdiffMicroslong(ZonedDateTime, ZonedDateTime)Returns the difference in microseconds between two zoned date time values.
FUNCTIONdiffMillislong(Instant, Instant)Returns the difference in milliseconds between two instant values.
FUNCTIONdiffMillislong(ZonedDateTime, ZonedDateTime)Returns the difference in milliseconds between two zoned date time values.
FUNCTIONdiffMinutesdouble(Instant, Instant)Returns the difference in minutes between two instant values.
FUNCTIONdiffMinutesdouble(ZonedDateTime, ZonedDateTime)Returns the difference in minutes between two zoned date time values.
FUNCTIONdiffNanoslong(Instant, Instant)Returns the difference in nanoseconds between two instant values.
FUNCTIONdiffNanoslong(ZonedDateTime, ZonedDateTime)Returns the difference in nanoseconds between two zoned date time values.
FUNCTIONdiffNonBusinessDurationDuration(Instant, Instant)Returns the amount of non-business time between two times.
FUNCTIONdiffNonBusinessDurationDuration(ZonedDateTime, ZonedDateTime)Returns the amount of non-business time between two times.
FUNCTIONdiffNonBusinessNanoslong(Instant, Instant)Returns the amount of non-business time in nanoseconds between two times.
FUNCTIONdiffNonBusinessNanoslong(ZonedDateTime, ZonedDateTime)Returns the amount of non-business time in nanoseconds between two times.
FUNCTIONdiffSecondsdouble(Instant, Instant)Returns the difference in seconds between two instant values.
FUNCTIONdiffSecondsdouble(ZonedDateTime, ZonedDateTime)Returns the difference in seconds between two zoned date time values.
FUNCTIONdiffYears365double(Instant, Instant)Returns the difference in years between two instant values. Years are defined in terms of 365 ...
FUNCTIONdiffYears365double(ZonedDateTime, ZonedDateTime)Returns the difference in years between two zoned date time values. Years are defined in terms...
FUNCTIONdiffYearsAvgdouble(Instant, Instant)Returns the difference in years between two instant values. Years are defined in terms of 365....
FUNCTIONdiffYearsAvgdouble(ZonedDateTime, ZonedDateTime)Returns the difference in years between two zoned date time values. Years are defined in terms...
FUNCTIONdivideDuration(Duration, long)Divide a duration by a scalar.
FUNCTIONepochAutoToEpochNanoslong(long)Converts an offset from the Epoch to a nanoseconds from the Epoch. The offset can be in milliseco...
FUNCTIONepochAutoToInstantInstant(long)Converts an offset from the Epoch to an Instant. The offset can be in milliseconds, microseconds,...
FUNCTIONepochAutoToZonedDateTimeZonedDateTime(long, ZoneId)Converts an offset from the Epoch to a ZonedDateTime. The offset can be in milliseconds, microsec...
FUNCTIONepochDayslong(LocalDate)Returns number of days from the Epoch for a LocalDate value.
FUNCTIONepochDaysAsIntint(LocalDate)Returns number of days (as an int) from the Epoch for a LocalDate value.
FUNCTIONepochDaysAsIntToLocalDateLocalDate(int)Converts days from the Epoch (stored as int) to a LocalDate.
FUNCTIONepochDaysToLocalDateLocalDate(long)Converts days from the Epoch to a LocalDate.
FUNCTIONepochMicroslong(Instant)Returns microseconds from the Epoch for an Instant value.
FUNCTIONepochMicroslong(ZonedDateTime)Returns microseconds from the Epoch for a ZonedDateTime value.
FUNCTIONepochMicrosToInstantInstant(long)Converts microseconds from the Epoch to an Instant.
FUNCTIONepochMicrosToZonedDateTimeZonedDateTime(long, ZoneId)Converts microseconds from the Epoch to a ZonedDateTime.
FUNCTIONepochMillislong(Instant)Returns milliseconds from the Epoch for an Instant value.
FUNCTIONepochMillislong(ZonedDateTime)Returns milliseconds from the Epoch for a ZonedDateTime value.
FUNCTIONepochMillisToInstantInstant(long)Converts milliseconds from the Epoch to an Instant.
FUNCTIONepochMillisToZonedDateTimeZonedDateTime(long, ZoneId)Converts milliseconds from the Epoch to a ZonedDateTime.
FUNCTIONepochNanoslong(Instant)Returns nanoseconds from the Epoch for an Instant value.
FUNCTIONepochNanoslong(ZonedDateTime)Returns nanoseconds from the Epoch for a ZonedDateTime value.
FUNCTIONepochNanosToInstantInstant(long)Converts nanoseconds from the Epoch to an Instant.
FUNCTIONepochNanosToZonedDateTimeZonedDateTime(long, ZoneId)Converts nanoseconds from the Epoch to a ZonedDateTime.
FUNCTIONepochSecondslong(Instant)Returns seconds since from the Epoch for an Instant value.
FUNCTIONepochSecondslong(ZonedDateTime)Returns seconds since from the Epoch for a ZonedDateTime value.
FUNCTIONepochSecondsToInstantInstant(long)Converts seconds from the Epoch to an Instant.
FUNCTIONepochSecondsToZonedDateTimeZonedDateTime(long, ZoneId)Converts seconds from the Epoch to a ZonedDateTime.
FUNCTIONexcelToInstantInstant(double, ZoneId)Converts an Excel time represented as a double to an Instant.
FUNCTIONexcelToZonedDateTimeZonedDateTime(double, ZoneId)Converts an Excel time represented as a double to a ZonedDateTime.
FUNCTIONformatDateString(Instant, ZoneId)Returns an Instant formatted as a "yyyy-MM-dd" string.
FUNCTIONformatDateString(LocalDate)Returns a LocalDate formatted as a "yyyy-MM-dd" string.
FUNCTIONformatDateString(LocalDateTime)Returns a LocalDateTime formatted as a "yyyy-MM-dd" string.
FUNCTIONformatDateString(ZonedDateTime)Returns a ZonedDateTime formatted as a "yyyy-MM-dd" string.
FUNCTIONformatDateTimeString(Instant, ZoneId)Returns an Instant formatted as a "yyyy-MM-ddThh:mm:ss.SSSSSSSSS TZ" string.
FUNCTIONformatDateTimeString(ZonedDateTime)Returns a ZonedDateTime formatted as a "yyyy-MM-ddThh:mm:ss.SSSSSSSSS TZ" string.
FUNCTIONformatDurationNanosString(long)Returns a nanosecond duration formatted as a "[-]PThhh:mm:ss.nnnnnnnnn" string.
FUNCTIONfractionBusinessDayCompletedouble()Fraction of the current business day complete.
FUNCTIONfractionBusinessDayCompletedouble(Instant)Fraction of the business day complete.
FUNCTIONfractionBusinessDayCompletedouble(ZonedDateTime)Fraction of the business day complete.
FUNCTIONfractionBusinessDayRemainingdouble()Fraction of the business day remaining.
FUNCTIONfractionBusinessDayRemainingdouble(Instant)Fraction of the business day remaining.
FUNCTIONfractionBusinessDayRemainingdouble(ZonedDateTime)Fraction of the business day remaining.
FUNCTIONfractionStandardBusinessDaydouble()Returns the ratio of the business day length and the standard business day length. For example, a...
FUNCTIONfractionStandardBusinessDaydouble(Instant)Returns the ratio of the business day length and the standard business day length. For example, a...
FUNCTIONfractionStandardBusinessDaydouble(LocalDate)Returns the ratio of the business day length and the standard business day length. For example, a...
FUNCTIONfractionStandardBusinessDaydouble(String)Returns the ratio of the business day length and the standard business day length. For example, a...
FUNCTIONfractionStandardBusinessDaydouble(ZonedDateTime)Returns the ratio of the business day length and the standard business day length. For example, a...
FUNCTIONfutureBusinessDateLocalDate(int)Adds a specified number of business days to the current date. Adding negative days is equivalent ...
FUNCTIONfutureDateLocalDate(int)Adds a specified number of days to the current date. Adding negative days is equivalent to subtra...
FUNCTIONfutureNonBusinessDateLocalDate(int)Adds a specified number of non-business days to the current date. Adding negative days is equival...
FUNCTIONholidaysMap()Business day schedules for all holidays. A holiday is a date that has a schedule that is differen...
FUNCTIONhourOfDayint(Instant, ZoneId, boolean)Returns the number of hours that have elapsed since the start of the day.
FUNCTIONhourOfDayint(LocalDateTime)Returns the number of hours that have elapsed since the start of the day.
FUNCTIONhourOfDayint(LocalTime)Returns the number of hours that have elapsed since the start of the day.
FUNCTIONhourOfDayint(ZonedDateTime, boolean)Returns the number of hours that have elapsed since the start of the day.
FUNCTIONisAfterboolean(Instant, Instant)Evaluates whether one instant value is after a second instant value.
FUNCTIONisAfterboolean(ZonedDateTime, ZonedDateTime)Evaluates whether one zoned date time value is after a second zoned date time value.
FUNCTIONisAfterOrEqualboolean(Instant, Instant)Evaluates whether one instant value is after or equal to a second instant value.
FUNCTIONisAfterOrEqualboolean(ZonedDateTime, ZonedDateTime)Evaluates whether one zoned date time value is after or equal to a second zoned date time value.
FUNCTIONisBeforeboolean(Instant, Instant)Evaluates whether one instant value is before a second instant value.
FUNCTIONisBeforeboolean(ZonedDateTime, ZonedDateTime)Evaluates whether one zoned date time value is before a second zoned date time value.
FUNCTIONisBeforeOrEqualboolean(Instant, Instant)Evaluates whether one instant value is before or equal to a second instant value.
FUNCTIONisBeforeOrEqualboolean(ZonedDateTime, ZonedDateTime)Evaluates whether one zoned date time value is before or equal to a second zoned date time value.
FUNCTIONisBusinessDayboolean()Is the current day a business day? As long as the current time occurs on a business day, it is co...
FUNCTIONisBusinessDayboolean(DayOfWeek)Is the day of the week a normal business day?.
FUNCTIONisBusinessDayboolean(Instant)Is the time on a business day? As long as the time occurs on a business day, it is considered ...
FUNCTIONisBusinessDayboolean(LocalDate)Is the date a business day?.
FUNCTIONisBusinessDayboolean(String)Is the date a business day?.
FUNCTIONisBusinessDayboolean(ZonedDateTime)Is the time on a business day? As long as the time occurs on a business day, it is considered ...
FUNCTIONisBusinessTimeboolean()Determines if the current time according to the Deephaven system clock is a business time. Busine...
FUNCTIONisBusinessTimeboolean(Instant)Determines if the specified time is a business time. Business times fall within business time ran...
FUNCTIONisBusinessTimeboolean(ZonedDateTime)Determines if the specified time is a business time. Business times fall within business time ran...
FUNCTIONisLastBusinessDayOfMonthboolean()Is the current date the last business day of the month?.
FUNCTIONisLastBusinessDayOfMonthboolean(Instant)Is the time on the last business day of the month? As long as the time occurs on a business da...
FUNCTIONisLastBusinessDayOfMonthboolean(String)Is the date the last business day of the month?.
FUNCTIONisLastBusinessDayOfMonthboolean(ZonedDateTime)Is the time on the last business day of the month? As long as the time occurs on a business da...
FUNCTIONisLastBusinessDayOfWeekboolean()Is the current date the last business day of the week?.
FUNCTIONisLastBusinessDayOfWeekboolean(Instant)Is the time on the last business day of the week? As long as the time occurs on a business day...
FUNCTIONisLastBusinessDayOfWeekboolean(LocalDate)Is the date the last business day of the week?.
FUNCTIONisLastBusinessDayOfWeekboolean(String)Is the date is last business day of the week?.
FUNCTIONisLastBusinessDayOfWeekboolean(ZonedDateTime)Is the time on the last business day of the week? As long as the time occurs on a business day...
FUNCTIONisLastBusinessDayOfYearboolean()Is the current date the last business day of the year? As long as the current time occurs on a...
FUNCTIONisLastBusinessDayOfYearboolean(Instant)Is the time on the last business day of the year? As long as the time occurs on a business day...
FUNCTIONisLastBusinessDayOfYearboolean(ZonedDateTime)Is the time on the last business day of the year? As long as the time occurs on a business day...
FUNCTIONlowerBinInstant(Instant, Duration)Returns an Instant value, which is at the starting (lower) end of a time range defined by the int...
FUNCTIONlowerBinInstant(Instant, Duration, Duration)Returns an Instant value, which is at the starting (lower) end of a time range defined by the int...
FUNCTIONlowerBinInstant(Instant, long)Returns an Instant value, which is at the starting (lower) end of a time range defined by the int...
FUNCTIONlowerBinInstant(Instant, long, long)Returns an Instant value, which is at the starting (lower) end of a time range defined by the int...
FUNCTIONlowerBinZonedDateTime(ZonedDateTime, Duration)Returns a ZonedDateTime value, which is at the starting (lower) end of a time range defined by th...
FUNCTIONlowerBinZonedDateTime(ZonedDateTime, Duration, Duration)Returns a ZonedDateTime value, which is at the starting (lower) end of a time range defined by th...
FUNCTIONlowerBinZonedDateTime(ZonedDateTime, long)Returns a ZonedDateTime value, which is at the starting (lower) end of a time range defined by th...
FUNCTIONlowerBinZonedDateTime(ZonedDateTime, long, long)Returns a ZonedDateTime value, which is at the starting (lower) end of a time range defined by th...
FUNCTIONmicrosOfDayToLocalTimeLocalTime(long)Converts the number of microseconds from midnight to a LocalTime.
FUNCTIONmicrosOfMilliint(Instant)Returns the number of microseconds that have elapsed since the top of the millisecond. Nanosecond...
FUNCTIONmicrosOfMilliint(ZonedDateTime)Returns the number of microseconds that have elapsed since the top of the millisecond. Nanosecond...
FUNCTIONmicrosOfSecondlong(Instant, ZoneId)Returns the number of microseconds that have elapsed since the top of the second.
FUNCTIONmicrosOfSecondlong(ZonedDateTime)Returns the number of microseconds that have elapsed since the top of the second.
FUNCTIONmicrosToMillislong(long)Converts microseconds to milliseconds.
FUNCTIONmicrosToNanoslong(long)Converts microseconds to nanoseconds.
FUNCTIONmicrosToSecondslong(long)Converts microseconds to seconds.
FUNCTIONmillisOfDayint(Instant, ZoneId, boolean)Returns the number of milliseconds that have elapsed since the start of the day.
FUNCTIONmillisOfDayint(LocalDateTime)Returns the number of milliseconds that have elapsed since the start of the day.
FUNCTIONmillisOfDayint(LocalTime)Returns the number of milliseconds that have elapsed since the start of the day.
FUNCTIONmillisOfDayint(ZonedDateTime, boolean)Returns the number of milliseconds that have elapsed since the start of the day.
FUNCTIONmillisOfDayToLocalTimeLocalTime(int)Converts the number of milliseconds from midnight to a LocalTime.
FUNCTIONmillisOfSecondint(Instant, ZoneId)Returns the number of milliseconds that have elapsed since the top of the second.
FUNCTIONmillisOfSecondint(ZonedDateTime)Returns the number of milliseconds that have elapsed since the top of the second.
FUNCTIONmillisToMicroslong(long)Converts milliseconds to microseconds.
FUNCTIONmillisToNanoslong(long)Converts milliseconds to nanoseconds.
FUNCTIONmillisToSecondslong(long)Converts milliseconds to seconds.
FUNCTIONminusDuration(Duration, Duration)Subtracts two durations.
FUNCTIONminusInstant(Instant, Duration)Subtracts a time period to an Instant.
FUNCTIONminusInstant(Instant, Period)Subtracts a time period to an Instant.
FUNCTIONminusInstant(Instant, long)Subtracts nanoseconds from an Instant.
FUNCTIONminusLocalDate(LocalDate, Period)Subtracts a time period from a LocalDate.
FUNCTIONminusLocalDateTime(LocalDateTime, Period)Subtracts a time period from a LocalDateTime.
FUNCTIONminusPeriod(Period, Period)Subtracts two periods.
FUNCTIONminusZonedDateTime(ZonedDateTime, Duration)Subtracts a time period to a ZonedDateTime.
FUNCTIONminusZonedDateTime(ZonedDateTime, Period)Subtracts a time period to a ZonedDateTime.
FUNCTIONminusZonedDateTime(ZonedDateTime, long)Subtracts nanoseconds from a ZonedDateTime.
FUNCTIONminuslong(Instant, Instant)Subtract one instant from another and return the difference in nanoseconds.
FUNCTIONminuslong(ZonedDateTime, ZonedDateTime)Subtract one zoned date time from another and return the difference in nanoseconds.
FUNCTIONminusBusinessDaysInstant(Instant, int)Subtracts a specified number of business days from an input time. Subtracting negative days is eq...
FUNCTIONminusBusinessDaysLocalDate(LocalDate, int)Subtracts a specified number of business days from an input date. Subtracting negative days is eq...
FUNCTIONminusBusinessDaysString(String, int)Subtracts a specified number of business days from an input date. Subtracting negative days is eq...
FUNCTIONminusBusinessDaysZonedDateTime(ZonedDateTime, int)Subtracts a specified number of business days from an input time. Subtracting negative days is eq...
FUNCTIONminusDaysInstant(Instant, int)Subtracts a specified number of days to an input time. Subtracting negative days is equivalent to...
FUNCTIONminusDaysLocalDate(LocalDate, int)Subtracts a specified number of days to an input date. Subtracting negative days is equivalent to...
FUNCTIONminusDaysLocalDate(LocalDate, long)Subtracts days from a LocalDate.
FUNCTIONminusDaysLocalDateTime(LocalDateTime, long)Subtracts days from a LocalDate.
FUNCTIONminusDaysString(String, int)Subtracts a specified number of days to an input date. Subtracting negative days is equivalent to...
FUNCTIONminusDaysZonedDateTime(ZonedDateTime, int)Subtracts a specified number of days to an input time. Subtracting negative days is equivalent to...
FUNCTIONminusNonBusinessDaysInstant(Instant, int)Subtracts a specified number of non-business days to an input time. Subtracting negative days is ...
FUNCTIONminusNonBusinessDaysLocalDate(LocalDate, int)Subtracts a specified number of non-business days to an input date. Subtracting negative days is ...
FUNCTIONminusNonBusinessDaysString(String, int)Subtracts a specified number of non-business days to an input date. Subtracting negative days is ...
FUNCTIONminusNonBusinessDaysZonedDateTime(ZonedDateTime, int)Subtracts a specified number of non-business days to an input time. Subtracting negative days is ...
FUNCTIONminuteOfDayint(Instant, ZoneId, boolean)Returns the number of minutes that have elapsed since the start of the day.
FUNCTIONminuteOfDayint(LocalDateTime)Returns the number of minutes that have elapsed since the start of the day.
FUNCTIONminuteOfDayint(LocalTime)Returns the number of minutes that have elapsed since the start of the day.
FUNCTIONminuteOfDayint(ZonedDateTime, boolean)Returns the number of minutes that have elapsed since the start of the day.
FUNCTIONminuteOfHourint(Instant, ZoneId)Returns the number of minutes that have elapsed since the top of the hour.
FUNCTIONminuteOfHourint(ZonedDateTime)Returns the number of minutes that have elapsed since the top of the hour.
FUNCTIONmonthOfYearint(Instant, ZoneId)Returns a 1-based int value of the month of the year (Julian date) for an Instant in the specifie...
FUNCTIONmonthOfYearint(LocalDate)Returns a 1-based int value of the month of the year (Julian date) for a LocalDate. January is 1,...
FUNCTIONmonthOfYearint(LocalDateTime)Returns a 1-based int value of the month of the year (Julian date) for a LocalDateTime. January i...
FUNCTIONmonthOfYearint(ZonedDateTime)Returns a 1-based int value of the month of the year (Julian date) for a ZonedDateTime in the spe...
FUNCTIONmultiplyDuration(Duration, long)Multiply a duration by a scalar.
FUNCTIONmultiplyDuration(long, Duration)Multiply a duration by a scalar.
FUNCTIONmultiplyPeriod(Period, int)Multiply a period by a scalar.
FUNCTIONmultiplyPeriod(int, Period)Multiply a period by a scalar.
FUNCTIONnanosOfDaylong(Instant, ZoneId, boolean)Returns the number of nanoseconds that have elapsed since the start of the day.
FUNCTIONnanosOfDaylong(LocalDateTime)Returns the number of nanoseconds that have elapsed since the start of the day.
FUNCTIONnanosOfDaylong(LocalTime)Returns the number of nanoseconds that have elapsed since the start of the day.
FUNCTIONnanosOfDaylong(ZonedDateTime, boolean)Returns the number of nanoseconds that have elapsed since the start of the day.
FUNCTIONnanosOfDayToLocalTimeLocalTime(long)Converts the number of nanoseconds from midnight to a LocalTime.
FUNCTIONnanosOfMilliint(Instant)Returns the number of nanoseconds that have elapsed since the top of the millisecond.
FUNCTIONnanosOfMilliint(ZonedDateTime)Returns the number of nanoseconds that have elapsed since the top of the millisecond.
FUNCTIONnanosOfSecondlong(Instant, ZoneId)Returns the number of nanoseconds that have elapsed since the top of the second.
FUNCTIONnanosOfSecondlong(ZonedDateTime)Returns the number of nanoseconds that have elapsed since the top of the second.
FUNCTIONnanosToMicroslong(long)Converts nanoseconds to microseconds.
FUNCTIONnanosToMillislong(long)Converts nanoseconds to milliseconds.
FUNCTIONnanosToSecondslong(long)Converts nanoseconds to seconds.
FUNCTIONnonBusinessDatesLocalDate[](Instant, Instant)Returns the non-business dates in a given range.
FUNCTIONnonBusinessDatesLocalDate[](Instant, Instant, boolean, boolean)Returns the non-business dates in a given range.
FUNCTIONnonBusinessDatesLocalDate[](LocalDate, LocalDate)Returns the non-business dates in a given range.
FUNCTIONnonBusinessDatesLocalDate[](LocalDate, LocalDate, boolean, boolean)Returns the non-business dates in a given range.
FUNCTIONnonBusinessDatesLocalDate[](ZonedDateTime, ZonedDateTime)Returns the non-business dates in a given range.
FUNCTIONnonBusinessDatesLocalDate[](ZonedDateTime, ZonedDateTime, boolean, boolean)Returns the non-business dates in a given range.
FUNCTIONnonBusinessDatesString[](String, String)Returns the non-business dates in a given range.
FUNCTIONnonBusinessDatesString[](String, String, boolean, boolean)Returns the non-business dates in a given range.
FUNCTIONnowInstant()Provides the current instant with nanosecond resolution according to the current clock. Under mos...
FUNCTIONnowMillisResolutionInstant()Provides the current instant with millisecond resolution according to the current clock. Under mo...
FUNCTIONnowSystemInstant()Provides the current instant with nanosecond resolution according to the system clock. Note that ...
FUNCTIONnowSystemMillisResolutionInstant()Provides the current instant with millisecond resolution according to the system clock. Note that...
FUNCTIONnumberBusinessDatesint(Instant, Instant)Returns the number of business dates in a given range.
FUNCTIONnumberBusinessDatesint(Instant, Instant, boolean, boolean)Returns the number of business dates in a given range.
FUNCTIONnumberBusinessDatesint(LocalDate, LocalDate)Returns the number of business dates in a given range.
FUNCTIONnumberBusinessDatesint(LocalDate, LocalDate, boolean, boolean)Returns the number of business dates in a given range.
FUNCTIONnumberBusinessDatesint(String, String)Returns the number of business dates in a given range.
FUNCTIONnumberBusinessDatesint(String, String, boolean, boolean)Returns the number of business dates in a given range.
FUNCTIONnumberBusinessDatesint(ZonedDateTime, ZonedDateTime)Returns the number of business dates in a given range.
FUNCTIONnumberBusinessDatesint(ZonedDateTime, ZonedDateTime, boolean, boolean)Returns the number of business dates in a given range.
FUNCTIONnumberCalendarDatesint(Instant, Instant)Returns the number of dates in a given range.
FUNCTIONnumberCalendarDatesint(Instant, Instant, boolean, boolean)Returns the number of dates in a given range.
FUNCTIONnumberCalendarDatesint(LocalDate, LocalDate)Returns the number of dates in a given range.
FUNCTIONnumberCalendarDatesint(LocalDate, LocalDate, boolean, boolean)Returns the number of dates in a given range.
FUNCTIONnumberCalendarDatesint(String, String)Returns the number of dates in a given range.
FUNCTIONnumberCalendarDatesint(String, String, boolean, boolean)Returns the number of dates in a given range.
FUNCTIONnumberCalendarDatesint(ZonedDateTime, ZonedDateTime)Returns the number of dates in a given range.
FUNCTIONnumberCalendarDatesint(ZonedDateTime, ZonedDateTime, boolean, boolean)Returns the number of dates in a given range.
FUNCTIONnumberNonBusinessDatesint(Instant, Instant)Returns the number of non-business dates in a given range.
FUNCTIONnumberNonBusinessDatesint(Instant, Instant, boolean, boolean)Returns the number of non-business dates in a given range.
FUNCTIONnumberNonBusinessDatesint(LocalDate, LocalDate)Returns the number of non-business dates in a given range.
FUNCTIONnumberNonBusinessDatesint(LocalDate, LocalDate, boolean, boolean)Returns the number of non-business dates in a given range.
FUNCTIONnumberNonBusinessDatesint(String, String)Returns the number of non-business dates in a given range.
FUNCTIONnumberNonBusinessDatesint(String, String, boolean, boolean)Returns the number of non-business dates in a given range.
FUNCTIONnumberNonBusinessDatesint(ZonedDateTime, ZonedDateTime)Returns the number of non-business dates in a given range.
FUNCTIONnumberNonBusinessDatesint(ZonedDateTime, ZonedDateTime, boolean, boolean)Returns the number of non-business dates in a given range.
FUNCTIONparseDurationDuration(String)Parses the string argument as a duration, which is a unit of time in terms of clock time (24-hour...
FUNCTIONparseDurationNanoslong(String)Parses the string argument as a time duration in nanoseconds. Time duration strings can be for...
FUNCTIONparseDurationNanosQuietlong(String)Parses the string argument as a time duration in nanoseconds. Time duration strings can be for...
FUNCTIONparseDurationQuietDuration(String)Parses the string argument as a duration, which is a unit of time in terms of clock time (24-hour...
FUNCTIONparseEpochNanoslong(String)Parses the string argument as nanoseconds since the Epoch. Date time strings are formatted acc...
FUNCTIONparseEpochNanosQuietlong(String)Parses the string argument as a nanoseconds since the Epoch. Date time strings are formatted a...
FUNCTIONparseInstantInstant(String)Parses the string argument as an Instant. Date time strings are formatted according to the ISO...
FUNCTIONparseInstantQuietInstant(String)Parses the string argument as an Instant. Date time strings are formatted according to the ISO...
FUNCTIONparseLocalDateLocalDate(String)Parses the string argument as a local date, which is a date without a time or time zone. Date ...
FUNCTIONparseLocalDateQuietLocalDate(String)Parses the string argument as a local date, which is a date without a time or time zone. Date ...
FUNCTIONparseLocalDateTimeLocalDateTime(String)Parses the string argument as a LocalDateTime. Date time strings are formatted according to th...
FUNCTIONparseLocalDateTimeQuietLocalDateTime(String)Parses the string argument as a LocalDateTime. Date time strings are formatted according to th...
FUNCTIONparseLocalTimeLocalTime(String)Parses the string argument as a local time, which is the time that would be read from a clock and...
FUNCTIONparseLocalTimeQuietLocalTime(String)Parses the string argument as a local time, which is the time that would be read from a clock and...
FUNCTIONparsePeriodPeriod(String)Parses the string argument as a period, which is a unit of time in terms of calendar time (days, ...
FUNCTIONparsePeriodQuietPeriod(String)Parses the string argument as a period, which is a unit of time in terms of calendar time (days, ...
FUNCTIONparseTimePrecisionChronoField(String)Returns a ChronoField indicating the level of precision in a time, datetime, or period nanos stri...
FUNCTIONparseTimePrecisionQuietChronoField(String)Returns a ChronoField indicating the level of precision in a time or datetime string.
FUNCTIONparseTimeZoneZoneId(String)Parses the string argument as a time zone.
FUNCTIONparseTimeZoneQuietZoneId(String)Parses the string argument as a time zone.
FUNCTIONparseZonedDateTimeZonedDateTime(String)Parses the string argument as a ZonedDateTime. Date time strings are formatted according to th...
FUNCTIONparseZonedDateTimeQuietZonedDateTime(String)Parses the string argument as a ZonedDateTime. Date time strings are formatted according to th...
FUNCTIONpastBusinessDateLocalDate(int)Subtracts a specified number of business days from the current date. Subtracting negative days is...
FUNCTIONpastDateLocalDate(int)Subtracts a specified number of days from the current date. Subtracting negative days is equivale...
FUNCTIONpastNonBusinessDateLocalDate(int)Subtracts a specified number of non-business days to the current date. Subtracting negative days ...
FUNCTIONplusDuration(Duration, Duration)Adds two durations.
FUNCTIONplusInstant(Instant, Duration)Adds a time period to an Instant.
FUNCTIONplusInstant(Instant, Period)Adds a time period to an Instant.
FUNCTIONplusInstant(Instant, long)Adds nanoseconds to an Instant.
FUNCTIONplusLocalDate(LocalDate, Period)Adds a time period to a LocalDate.
FUNCTIONplusLocalDateTime(LocalDateTime, Period)Adds a time period to a LocalDateTime.
FUNCTIONplusPeriod(Period, Period)Adds two periods.
FUNCTIONplusZonedDateTime(ZonedDateTime, Duration)Adds a time period to a ZonedDateTime.
FUNCTIONplusZonedDateTime(ZonedDateTime, Period)Adds a time period to a ZonedDateTime.
FUNCTIONplusZonedDateTime(ZonedDateTime, long)Adds nanoseconds to a ZonedDateTime.
FUNCTIONplusBusinessDaysInstant(Instant, int)Adds a specified number of business days to an input time. Adding negative days is equivalent to ...
FUNCTIONplusBusinessDaysLocalDate(LocalDate, int)Adds a specified number of business days to an input date. Adding negative days is equivalent to ...
FUNCTIONplusBusinessDaysString(String, int)Adds a specified number of business days to an input date. Adding negative days is equivalent to ...
FUNCTIONplusBusinessDaysZonedDateTime(ZonedDateTime, int)Adds a specified number of business days to an input time. Adding negative days is equivalent to ...
FUNCTIONplusDaysInstant(Instant, int)Adds a specified number of days to an input time. Adding negative days is equivalent to subtracti...
FUNCTIONplusDaysLocalDate(LocalDate, int)Adds a specified number of days to an input date. Adding negative days is equivalent to subtracti...
FUNCTIONplusDaysLocalDate(LocalDate, long)Adds days to a LocalDate.
FUNCTIONplusDaysLocalDateTime(LocalDateTime, long)Adds days to a LocalDate.
FUNCTIONplusDaysString(String, int)Adds a specified number of days to an input date. Adding negative days is equivalent to subtracti...
FUNCTIONplusDaysZonedDateTime(ZonedDateTime, int)Adds a specified number of days to an input time. Adding negative days is equivalent to subtracti...
FUNCTIONplusNonBusinessDaysInstant(Instant, int)Adds a specified number of non-business days to an input time. Adding negative days is equivalent...
FUNCTIONplusNonBusinessDaysLocalDate(LocalDate, int)Adds a specified number of non-business days to an input date. Adding negative days is equivalent...
FUNCTIONplusNonBusinessDaysString(String, int)Adds a specified number of non-business days to an input date. Adding negative days is equivalent...
FUNCTIONplusNonBusinessDaysZonedDateTime(ZonedDateTime, int)Adds a specified number of non-business days to an input time. Adding negative days is equivalent...
FUNCTIONremoveCalendarvoid(String)Removes a calendar from the collection.
FUNCTIONsecondOfDayint(Instant, ZoneId, boolean)Returns the number of seconds that have elapsed since the start of the day.
FUNCTIONsecondOfDayint(LocalDateTime)Returns the number of seconds that have elapsed since the start of the day.
FUNCTIONsecondOfDayint(LocalTime)Returns the number of seconds that have elapsed since the start of the day.
FUNCTIONsecondOfDayint(ZonedDateTime, boolean)Returns the number of seconds that have elapsed since the start of the day.
FUNCTIONsecondOfMinuteint(Instant, ZoneId)Returns the number of seconds that have elapsed since the top of the minute.
FUNCTIONsecondOfMinuteint(ZonedDateTime)Returns the number of seconds that have elapsed since the top of the minute.
FUNCTIONsecondsToMicroslong(long)Converts seconds to microseconds.
FUNCTIONsecondsToMillislong(long)Converts seconds to milliseconds.
FUNCTIONsecondsToNanoslong(long)Converts seconds to nanoseconds.
FUNCTIONsetCalendarvoid(String)Sets the default calendar by name. The calendar must already be present in the collection.
FUNCTIONsetClockvoid(Clock)Set the clock used to compute the current time. This allows a custom clock to be used instead of ...
FUNCTIONstandardBusinessDayCalendarDay()Business day schedule for a standard business day.
FUNCTIONstandardBusinessDurationDuration()Length of a standard business day.
FUNCTIONstandardBusinessNanoslong()Length of a standard business day in nanoseconds.
FUNCTIONtimeZoneZoneId()Gets the system default time zone.
FUNCTIONtimeZoneZoneId(String)Gets the time zone for a time zone name.
FUNCTIONtimeZoneAliasAddvoid(String, String)Adds a new time zone alias.
FUNCTIONtimeZoneAliasRmboolean(String)Removes a time zone alias.
FUNCTIONtoDateDate(Instant)Converts an Instant to a Date. instant will be truncated to millisecond resolution.
FUNCTIONtoDateDate(ZonedDateTime)Converts a ZonedDateTime to a Date. dateTime will be truncated to millisecond resolution.
FUNCTIONtoExcelTimedouble(Instant, ZoneId)Converts an Instant to an Excel time represented as a double.
FUNCTIONtoExcelTimedouble(ZonedDateTime)Converts a ZonedDateTime to an Excel time represented as a double.
FUNCTIONtoInstantInstant(Date)Converts a Date to an Instant.
FUNCTIONtoInstantInstant(LocalDate, LocalTime, ZoneId)Converts a LocalDate, LocalTime, and ZoneId to an Instant.
FUNCTIONtoInstantInstant(LocalDateTime, ZoneId)Converts a LocalDateTime and ZoneId to an Instant.
FUNCTIONtoInstantInstant(ZonedDateTime)Converts a ZonedDateTime to an Instant.
FUNCTIONtoLocalDateLocalDate(Instant, ZoneId)Converts an Instant to a LocalDate with the specified ZoneId.
FUNCTIONtoLocalDateLocalDate(LocalDateTime)Gets the LocalDate portion of a LocalDateTime.
FUNCTIONtoLocalDateLocalDate(ZonedDateTime)Gets the LocalDate portion of a ZonedDateTime.
FUNCTIONtoLocalDateTimeLocalDateTime(Instant, ZoneId)Converts an Instant to a LocalDateTime with the specified ZoneId.
FUNCTIONtoLocalDateTimeLocalDateTime(LocalDate, LocalTime)Converts a LocalDate and LocalTime pair to a LocalDateTime.
FUNCTIONtoLocalDateTimeLocalDateTime(ZonedDateTime)Gets the LocalDateTime portion of a ZonedDateTime.
FUNCTIONtoLocalTimeLocalTime(Instant, ZoneId)Converts an Instant to a LocalTime with the specified ZoneId.
FUNCTIONtoLocalTimeLocalTime(LocalDateTime)Gets the LocalTime portion of a LocalDateTime.
FUNCTIONtoLocalTimeLocalTime(ZonedDateTime)Gets the LocalTime portion of a ZonedDateTime.
FUNCTIONtoZonedDateTimeZonedDateTime(Instant, ZoneId)Converts an Instant to a ZonedDateTime.
FUNCTIONtoZonedDateTimeZonedDateTime(LocalDate, LocalTime, ZoneId)Converts a LocalDate, LocalTime, and ZoneId to a ZonedDateTime.
FUNCTIONtoZonedDateTimeZonedDateTime(LocalDateTime, ZoneId)Converts a LocalDateTime and ZoneId to a ZonedDateTime.
FUNCTIONtodayString()Provides the current date string according to the current clock and the default time zone. Under...
FUNCTIONtodayString(ZoneId)Provides the current date string according to the current clock. Under most circumstances, this ...
FUNCTIONtodayLocalDateLocalDate()Provides the current date according to the current clock and the default time zone. Under most c...
FUNCTIONtodayLocalDateLocalDate(ZoneId)Provides the current date according to the current clock. Under most circumstances, this method ...
FUNCTIONupperBinInstant(Instant, Duration)Returns an Instant value, which is at the ending (upper) end of a time range defined by the inter...
FUNCTIONupperBinInstant(Instant, Duration, Duration)Returns an Instant value, which is at the ending (upper) end of a time range defined by the inter...
FUNCTIONupperBinInstant(Instant, long)Returns an Instant value, which is at the ending (upper) end of a time range defined by the inter...
FUNCTIONupperBinInstant(Instant, long, long)Returns an Instant value, which is at the ending (upper) end of a time range defined by the inter...
FUNCTIONupperBinZonedDateTime(ZonedDateTime, Duration)Returns a ZonedDateTime value, which is at the ending (upper) end of a time range defined by the ...
FUNCTIONupperBinZonedDateTime(ZonedDateTime, Duration, Duration)Returns a ZonedDateTime value, which is at the ending (upper) end of a time range defined by the ...
FUNCTIONupperBinZonedDateTime(ZonedDateTime, long)Returns a ZonedDateTime value, which is at the ending (upper) end of a time range defined by the ...
FUNCTIONupperBinZonedDateTime(ZonedDateTime, long, long)Returns a ZonedDateTime value, which is at the ending (upper) end of a time range defined by the ...
FUNCTIONweekendDaysSet()Returns the days that make up a weekend.
FUNCTIONyearint(Instant, ZoneId)Returns the year for an Instant in the specified time zone.
FUNCTIONyearint(LocalDate)Returns the year for a LocalDate.
FUNCTIONyearint(LocalDateTime)Returns the year for a LocalDateTime.
FUNCTIONyearint(ZonedDateTime)Returns the year for a ZonedDateTime in the specified time zone.
FUNCTIONyearOfCenturyint(Instant, ZoneId)Returns the year of the century (two-digit year) for an Instant in the specified time zone.
FUNCTIONyearOfCenturyint(LocalDate)Returns the year of the century (two-digit year) for a LocalDate.
FUNCTIONyearOfCenturyint(LocalDateTime)Returns the year of the century (two-digit year) for a LocalDateTime.
FUNCTIONyearOfCenturyint(ZonedDateTime)Returns the year of the century (two-digit year) for a ZonedDateTime in the specified time zone.