Package io.prestosql.operator.scalar
Class DateTimeFunctions
- java.lang.Object
-
- io.prestosql.operator.scalar.DateTimeFunctions
-
public final class DateTimeFunctions extends Object
-
-
Nested Class Summary
Nested Classes Modifier and Type Class Description static class
DateTimeFunctions.FromUnixtimeNanosDecimal
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static long
addFieldValueDate(ConnectorSession session, io.airlift.slice.Slice unit, long value, long date)
static org.joda.time.format.DateTimeFormatter
createDateTimeFormatter(io.airlift.slice.Slice format)
static long
currentDate(ConnectorSession session)
static io.airlift.slice.Slice
currentTimeZone(ConnectorSession session)
static io.airlift.slice.Slice
dateFormat(org.joda.time.chrono.ISOChronology chronology, Locale locale, long timestamp, io.airlift.slice.Slice formatString)
static long
dateParse(ConnectorSession session, io.airlift.slice.Slice dateTime, io.airlift.slice.Slice formatString)
static long
dayFromDate(long date)
static long
dayFromInterval(long milliseconds)
static long
dayOfWeekFromDate(long date)
static long
dayOfYearFromDate(long date)
static long
diffDate(ConnectorSession session, io.airlift.slice.Slice unit, long date1, long date2)
static long
fromISO8601Date(ConnectorSession session, io.airlift.slice.Slice iso8601DateTime)
static long
fromISO8601Timestamp(ConnectorSession session, io.airlift.slice.Slice iso8601DateTime)
static LongTimestampWithTimeZone
fromIso8601TimestampNanos(ConnectorSession session, io.airlift.slice.Slice iso8601DateTime)
static long
fromUnixTime(double unixTime)
static long
fromUnixTime(double unixTime, long hoursOffset, long minutesOffset)
static long
fromUnixTime(double unixTime, io.airlift.slice.Slice zoneId)
static LongTimestamp
fromUnixtimeNanosLong(long unixTimeNanos)
static org.joda.time.DateTimeField
getTimestampField(org.joda.time.chrono.ISOChronology chronology, io.airlift.slice.Slice unit)
static long
hourFromInterval(long milliseconds)
static long
lastDayOfMonthFromDate(long date)
static long
millisecondFromInterval(long milliseconds)
static long
minuteFromInterval(long milliseconds)
static long
monthFromDate(long date)
static long
monthFromInterval(long months)
static long
now(ConnectorSession session)
static long
parseDatetime(ConnectorSession session, io.airlift.slice.Slice datetime, io.airlift.slice.Slice formatString)
static long
parseDuration(io.airlift.slice.Slice duration)
static long
quarterFromDate(long date)
static long
secondFromInterval(long milliseconds)
static io.airlift.slice.Slice
toISO8601FromDate(ConnectorSession session, long date)
static long
toMilliseconds(long value)
static long
truncateDate(ConnectorSession session, io.airlift.slice.Slice unit, long date)
static long
valueToSessionTimeZoneOffsetDiff(long epochMillis, org.joda.time.DateTimeZone timeZone)
static long
weekFromDate(long date)
static long
yearFromDate(long date)
static long
yearFromInterval(long months)
static long
yearOfWeekFromDate(long date)
-
-
-
Method Detail
-
now
public static long now(ConnectorSession session)
-
currentDate
public static long currentDate(ConnectorSession session)
-
currentTimeZone
public static io.airlift.slice.Slice currentTimeZone(ConnectorSession session)
-
fromUnixTime
public static long fromUnixTime(double unixTime)
-
fromUnixTime
public static long fromUnixTime(double unixTime, long hoursOffset, long minutesOffset)
-
fromUnixTime
public static long fromUnixTime(double unixTime, io.airlift.slice.Slice zoneId)
-
fromUnixtimeNanosLong
public static LongTimestamp fromUnixtimeNanosLong(long unixTimeNanos)
-
toISO8601FromDate
public static io.airlift.slice.Slice toISO8601FromDate(ConnectorSession session, long date)
-
fromISO8601Timestamp
public static long fromISO8601Timestamp(ConnectorSession session, io.airlift.slice.Slice iso8601DateTime)
-
fromIso8601TimestampNanos
public static LongTimestampWithTimeZone fromIso8601TimestampNanos(ConnectorSession session, io.airlift.slice.Slice iso8601DateTime)
-
fromISO8601Date
public static long fromISO8601Date(ConnectorSession session, io.airlift.slice.Slice iso8601DateTime)
-
truncateDate
public static long truncateDate(ConnectorSession session, io.airlift.slice.Slice unit, long date)
-
addFieldValueDate
public static long addFieldValueDate(ConnectorSession session, io.airlift.slice.Slice unit, long value, long date)
-
diffDate
public static long diffDate(ConnectorSession session, io.airlift.slice.Slice unit, long date1, long date2)
-
getTimestampField
public static org.joda.time.DateTimeField getTimestampField(org.joda.time.chrono.ISOChronology chronology, io.airlift.slice.Slice unit)
-
parseDatetime
public static long parseDatetime(ConnectorSession session, io.airlift.slice.Slice datetime, io.airlift.slice.Slice formatString)
-
dateFormat
public static io.airlift.slice.Slice dateFormat(org.joda.time.chrono.ISOChronology chronology, Locale locale, long timestamp, io.airlift.slice.Slice formatString)
-
dateParse
public static long dateParse(ConnectorSession session, io.airlift.slice.Slice dateTime, io.airlift.slice.Slice formatString)
-
millisecondFromInterval
public static long millisecondFromInterval(long milliseconds)
-
secondFromInterval
public static long secondFromInterval(long milliseconds)
-
minuteFromInterval
public static long minuteFromInterval(long milliseconds)
-
hourFromInterval
public static long hourFromInterval(long milliseconds)
-
dayOfWeekFromDate
public static long dayOfWeekFromDate(long date)
-
dayFromDate
public static long dayFromDate(long date)
-
dayFromInterval
public static long dayFromInterval(long milliseconds)
-
lastDayOfMonthFromDate
public static long lastDayOfMonthFromDate(long date)
-
dayOfYearFromDate
public static long dayOfYearFromDate(long date)
-
weekFromDate
public static long weekFromDate(long date)
-
yearOfWeekFromDate
public static long yearOfWeekFromDate(long date)
-
monthFromDate
public static long monthFromDate(long date)
-
monthFromInterval
public static long monthFromInterval(long months)
-
quarterFromDate
public static long quarterFromDate(long date)
-
yearFromDate
public static long yearFromDate(long date)
-
yearFromInterval
public static long yearFromInterval(long months)
-
createDateTimeFormatter
public static org.joda.time.format.DateTimeFormatter createDateTimeFormatter(io.airlift.slice.Slice format)
-
parseDuration
public static long parseDuration(io.airlift.slice.Slice duration)
-
valueToSessionTimeZoneOffsetDiff
public static long valueToSessionTimeZoneOffsetDiff(long epochMillis, org.joda.time.DateTimeZone timeZone)
-
toMilliseconds
public static long toMilliseconds(long value)
-
-