io.prestosql.operator.scalar

Class DateTimeFunctions

java.lang.Object

io.prestosql.operator.scalar.DateTimeFunctions

public final class DateTimeFunctions
extends Object

Method Summary

Modifier and Type	Method and Description
static long	addFieldValueDate(ConnectorSession session, io.airlift.slice.Slice unit, long value, long date)
static long	addFieldValueTime(ConnectorSession session, io.airlift.slice.Slice unit, long value, long time)
static long	addFieldValueTimestamp(ConnectorSession session, io.airlift.slice.Slice unit, long value, long timestamp)
static long	addFieldValueTimestampWithTimeZone(io.airlift.slice.Slice unit, long value, long timestampWithTimeZone)
static long	addFieldValueTimeWithTimeZone(io.airlift.slice.Slice unit, long value, long timeWithTimeZone)
static org.joda.time.format.DateTimeFormatter	createDateTimeFormatter(io.airlift.slice.Slice format)
static long	currentDate(ConnectorSession session)
static long	currentTime(ConnectorSession session)
static long	currentTimestamp(ConnectorSession session)
static io.airlift.slice.Slice	currentTimeZone(ConnectorSession session)
static io.airlift.slice.Slice	dateFormat(ConnectorSession session, long timestamp, io.airlift.slice.Slice formatString)
static io.airlift.slice.Slice	dateFormatWithTimeZone(ConnectorSession session, long timestampWithTimeZone, 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	dayFromTimestamp(ConnectorSession session, long timestamp)
static long	dayFromTimestampWithTimeZone(long timestampWithTimeZone)
static long	dayOfWeekFromDate(long date)
static long	dayOfWeekFromTimestamp(ConnectorSession session, long timestamp)
static long	dayOfWeekFromTimestampWithTimeZone(long timestampWithTimeZone)
static long	dayOfYearFromDate(long date)
static long	dayOfYearFromTimestamp(ConnectorSession session, long timestamp)
static long	dayOfYearFromTimestampWithTimeZone(long timestampWithTimeZone)
static long	diffDate(ConnectorSession session, io.airlift.slice.Slice unit, long date1, long date2)
static long	diffTime(ConnectorSession session, io.airlift.slice.Slice unit, long time1, long time2)
static long	diffTimestamp(ConnectorSession session, io.airlift.slice.Slice unit, long timestamp1, long timestamp2)
static long	diffTimestampWithTimeZone(io.airlift.slice.Slice unit, long timestampWithTimeZone1, long timestampWithTimeZone2)
static long	diffTimeWithTimeZone(io.airlift.slice.Slice unit, long timeWithTimeZone1, long timeWithTimeZone2)
static io.airlift.slice.Slice	formatDatetime(ConnectorSession session, long timestamp, io.airlift.slice.Slice formatString)
static io.airlift.slice.Slice	formatDatetimeWithTimeZone(ConnectorSession session, long timestampWithTimeZone, io.airlift.slice.Slice formatString)
static long	fromISO8601Date(ConnectorSession session, io.airlift.slice.Slice iso8601DateTime)
static long	fromISO8601Timestamp(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 long	hourFromInterval(long milliseconds)
static long	hourFromTime(ConnectorSession session, long time)
static long	hourFromTimestamp(ConnectorSession session, long timestamp)
static long	hourFromTimestampWithTimeZone(long timestampWithTimeZone)
static long	hourFromTimeWithTimeZone(long timeWithTimeZone)
static long	localTime(ConnectorSession session)
static long	localTimestamp(ConnectorSession session)
static long	millisecondFromInterval(long milliseconds)
static long	millisecondFromTime(long time)
static long	millisecondFromTimestamp(long timestamp)
static long	millisecondFromTimestampWithTimeZone(long timestampWithTimeZone)
static long	millisecondFromTimeWithTimeZone(long time)
static long	minuteFromInterval(long milliseconds)
static long	minuteFromTime(ConnectorSession session, long time)
static long	minuteFromTimestamp(ConnectorSession session, long timestamp)
static long	minuteFromTimestampWithTimeZone(long timestampWithTimeZone)
static long	minuteFromTimeWithTimeZone(long timeWithTimeZone)
static long	monthFromDate(long date)
static long	monthFromInterval(long months)
static long	monthFromTimestamp(ConnectorSession session, long timestamp)
static long	monthFromTimestampWithTimeZone(long timestampWithTimeZone)
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	quarterFromTimestamp(ConnectorSession session, long timestamp)
static long	quarterFromTimestampWithTimeZone(long timestampWithTimeZone)
static long	secondFromInterval(long milliseconds)
static long	secondFromTime(long time)
static long	secondFromTimestamp(long timestamp)
static long	secondFromTimestampWithTimeZone(long timestampWithTimeZone)
static long	secondFromTimeWithTimeZone(long time)
static long	timeAtTimeZone(ConnectorSession session, long timeWithTimeZone, long zoneOffset)
static long	timeAtTimeZone(ConnectorSession session, long timeWithTimeZone, io.airlift.slice.Slice zoneId)
static long	timestampAtTimeZone(long timestampWithTimeZone, long zoneOffset)
static long	timestampAtTimeZone(long timestampWithTimeZone, io.airlift.slice.Slice zoneId)
static long	timeZoneHourFromTimestampWithTimeZone(long timestampWithTimeZone)
static long	timeZoneMinuteFromTimestampWithTimeZone(long timestampWithTimeZone)
static io.airlift.slice.Slice	toISO8601FromDate(ConnectorSession session, long date)
static io.airlift.slice.Slice	toISO8601FromTimestamp(ConnectorSession session, long timestamp)
static io.airlift.slice.Slice	toISO8601FromTimestampWithTimeZone(long timestampWithTimeZone)
static long	toMilliseconds(long value)
static double	toUnixTime(long timestamp)
static double	toUnixTimeFromTimestampWithTimeZone(long timestampWithTimeZone)
static long	truncateDate(ConnectorSession session, io.airlift.slice.Slice unit, long date)
static long	truncateTime(ConnectorSession session, io.airlift.slice.Slice unit, long time)
static long	truncateTimestamp(ConnectorSession session, io.airlift.slice.Slice unit, long timestamp)
static long	truncateTimestampWithTimezone(io.airlift.slice.Slice unit, long timestampWithTimeZone)
static long	truncateTimeWithTimeZone(io.airlift.slice.Slice unit, long timeWithTimeZone)
static long	weekFromDate(long date)
static long	weekFromTimestamp(ConnectorSession session, long timestamp)
static long	weekFromTimestampWithTimeZone(long timestampWithTimeZone)
static long	yearFromDate(long date)
static long	yearFromInterval(long months)
static long	yearFromTimestamp(ConnectorSession session, long timestamp)
static long	yearFromTimestampWithTimeZone(long timestampWithTimeZone)
static long	yearOfWeekFromDate(long date)
static long	yearOfWeekFromTimestamp(ConnectorSession session, long timestamp)
static long	yearOfWeekFromTimestampWithTimeZone(long timestampWithTimeZone)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

currentDate

public static long currentDate(ConnectorSession session)

currentTime

public static long currentTime(ConnectorSession session)

localTime

public static long localTime(ConnectorSession session)

currentTimeZone

public static io.airlift.slice.Slice currentTimeZone(ConnectorSession session)

currentTimestamp

public static long currentTimestamp(ConnectorSession session)

localTimestamp

public static long localTimestamp(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)

toUnixTime

public static double toUnixTime(long timestamp)

toUnixTimeFromTimestampWithTimeZone

public static double toUnixTimeFromTimestampWithTimeZone(long timestampWithTimeZone)

toISO8601FromTimestamp

public static io.airlift.slice.Slice toISO8601FromTimestamp(ConnectorSession session,
                                                            long timestamp)

toISO8601FromTimestampWithTimeZone

public static io.airlift.slice.Slice toISO8601FromTimestampWithTimeZone(long timestampWithTimeZone)

toISO8601FromDate

public static io.airlift.slice.Slice toISO8601FromDate(ConnectorSession session,
                                                       long date)

fromISO8601Timestamp

public static long fromISO8601Timestamp(ConnectorSession session,
                                        io.airlift.slice.Slice iso8601DateTime)

fromISO8601Date

public static long fromISO8601Date(ConnectorSession session,
                                   io.airlift.slice.Slice iso8601DateTime)

timeAtTimeZone

public static long timeAtTimeZone(ConnectorSession session,
                                  long timeWithTimeZone,
                                  io.airlift.slice.Slice zoneId)

timeAtTimeZone

public static long timeAtTimeZone(ConnectorSession session,
                                  long timeWithTimeZone,
                                  long zoneOffset)

timestampAtTimeZone

public static long timestampAtTimeZone(long timestampWithTimeZone,
                                       io.airlift.slice.Slice zoneId)

timestampAtTimeZone

public static long timestampAtTimeZone(long timestampWithTimeZone,
                                       long zoneOffset)

truncateDate

public static long truncateDate(ConnectorSession session,
                                io.airlift.slice.Slice unit,
                                long date)

truncateTime

public static long truncateTime(ConnectorSession session,
                                io.airlift.slice.Slice unit,
                                long time)

truncateTimeWithTimeZone

public static long truncateTimeWithTimeZone(io.airlift.slice.Slice unit,
                                            long timeWithTimeZone)

truncateTimestamp

public static long truncateTimestamp(ConnectorSession session,
                                     io.airlift.slice.Slice unit,
                                     long timestamp)

truncateTimestampWithTimezone

public static long truncateTimestampWithTimezone(io.airlift.slice.Slice unit,
                                                 long timestampWithTimeZone)

addFieldValueDate

public static long addFieldValueDate(ConnectorSession session,
                                     io.airlift.slice.Slice unit,
                                     long value,
                                     long date)

addFieldValueTime

public static long addFieldValueTime(ConnectorSession session,
                                     io.airlift.slice.Slice unit,
                                     long value,
                                     long time)

addFieldValueTimeWithTimeZone

public static long addFieldValueTimeWithTimeZone(io.airlift.slice.Slice unit,
                                                 long value,
                                                 long timeWithTimeZone)

addFieldValueTimestamp

public static long addFieldValueTimestamp(ConnectorSession session,
                                          io.airlift.slice.Slice unit,
                                          long value,
                                          long timestamp)

addFieldValueTimestampWithTimeZone

public static long addFieldValueTimestampWithTimeZone(io.airlift.slice.Slice unit,
                                                      long value,
                                                      long timestampWithTimeZone)

diffDate

public static long diffDate(ConnectorSession session,
                            io.airlift.slice.Slice unit,
                            long date1,
                            long date2)

diffTime

public static long diffTime(ConnectorSession session,
                            io.airlift.slice.Slice unit,
                            long time1,
                            long time2)

diffTimeWithTimeZone

public static long diffTimeWithTimeZone(io.airlift.slice.Slice unit,
                                        long timeWithTimeZone1,
                                        long timeWithTimeZone2)

diffTimestamp

public static long diffTimestamp(ConnectorSession session,
                                 io.airlift.slice.Slice unit,
                                 long timestamp1,
                                 long timestamp2)

diffTimestampWithTimeZone

public static long diffTimestampWithTimeZone(io.airlift.slice.Slice unit,
                                             long timestampWithTimeZone1,
                                             long timestampWithTimeZone2)

parseDatetime

public static long parseDatetime(ConnectorSession session,
                                 io.airlift.slice.Slice datetime,
                                 io.airlift.slice.Slice formatString)

formatDatetime

public static io.airlift.slice.Slice formatDatetime(ConnectorSession session,
                                                    long timestamp,
                                                    io.airlift.slice.Slice formatString)

formatDatetimeWithTimeZone

public static io.airlift.slice.Slice formatDatetimeWithTimeZone(ConnectorSession session,
                                                                long timestampWithTimeZone,
                                                                io.airlift.slice.Slice formatString)

dateFormat

public static io.airlift.slice.Slice dateFormat(ConnectorSession session,
                                                long timestamp,
                                                io.airlift.slice.Slice formatString)

dateFormatWithTimeZone

public static io.airlift.slice.Slice dateFormatWithTimeZone(ConnectorSession session,
                                                            long timestampWithTimeZone,
                                                            io.airlift.slice.Slice formatString)

dateParse

public static long dateParse(ConnectorSession session,
                             io.airlift.slice.Slice dateTime,
                             io.airlift.slice.Slice formatString)

millisecondFromTimestamp

public static long millisecondFromTimestamp(long timestamp)

millisecondFromTimestampWithTimeZone

public static long millisecondFromTimestampWithTimeZone(long timestampWithTimeZone)

millisecondFromTime

public static long millisecondFromTime(long time)

millisecondFromTimeWithTimeZone

public static long millisecondFromTimeWithTimeZone(long time)

millisecondFromInterval

public static long millisecondFromInterval(long milliseconds)

secondFromTimestamp

public static long secondFromTimestamp(long timestamp)

secondFromTimestampWithTimeZone

public static long secondFromTimestampWithTimeZone(long timestampWithTimeZone)

secondFromTime

public static long secondFromTime(long time)

secondFromTimeWithTimeZone

public static long secondFromTimeWithTimeZone(long time)

secondFromInterval

public static long secondFromInterval(long milliseconds)

minuteFromTimestamp

public static long minuteFromTimestamp(ConnectorSession session,
                                       long timestamp)

minuteFromTimestampWithTimeZone

public static long minuteFromTimestampWithTimeZone(long timestampWithTimeZone)

minuteFromTime

public static long minuteFromTime(ConnectorSession session,
                                  long time)

minuteFromTimeWithTimeZone

public static long minuteFromTimeWithTimeZone(long timeWithTimeZone)

minuteFromInterval

public static long minuteFromInterval(long milliseconds)

hourFromTimestamp

public static long hourFromTimestamp(ConnectorSession session,
                                     long timestamp)

hourFromTimestampWithTimeZone

public static long hourFromTimestampWithTimeZone(long timestampWithTimeZone)

hourFromTime

public static long hourFromTime(ConnectorSession session,
                                long time)

hourFromTimeWithTimeZone

public static long hourFromTimeWithTimeZone(long timeWithTimeZone)

hourFromInterval

public static long hourFromInterval(long milliseconds)

dayOfWeekFromTimestamp

public static long dayOfWeekFromTimestamp(ConnectorSession session,
                                          long timestamp)

dayOfWeekFromTimestampWithTimeZone

public static long dayOfWeekFromTimestampWithTimeZone(long timestampWithTimeZone)

dayOfWeekFromDate

public static long dayOfWeekFromDate(long date)

dayFromTimestamp

public static long dayFromTimestamp(ConnectorSession session,
                                    long timestamp)

dayFromTimestampWithTimeZone

public static long dayFromTimestampWithTimeZone(long timestampWithTimeZone)

dayFromDate

public static long dayFromDate(long date)

dayFromInterval

public static long dayFromInterval(long milliseconds)

dayOfYearFromTimestamp

public static long dayOfYearFromTimestamp(ConnectorSession session,
                                          long timestamp)

dayOfYearFromTimestampWithTimeZone

public static long dayOfYearFromTimestampWithTimeZone(long timestampWithTimeZone)

dayOfYearFromDate

public static long dayOfYearFromDate(long date)

weekFromTimestamp

public static long weekFromTimestamp(ConnectorSession session,
                                     long timestamp)

weekFromTimestampWithTimeZone

public static long weekFromTimestampWithTimeZone(long timestampWithTimeZone)

weekFromDate

public static long weekFromDate(long date)

yearOfWeekFromTimestamp

public static long yearOfWeekFromTimestamp(ConnectorSession session,
                                           long timestamp)

yearOfWeekFromTimestampWithTimeZone

public static long yearOfWeekFromTimestampWithTimeZone(long timestampWithTimeZone)

yearOfWeekFromDate

public static long yearOfWeekFromDate(long date)

monthFromTimestamp

public static long monthFromTimestamp(ConnectorSession session,
                                      long timestamp)

monthFromTimestampWithTimeZone

public static long monthFromTimestampWithTimeZone(long timestampWithTimeZone)

monthFromDate

public static long monthFromDate(long date)

monthFromInterval

public static long monthFromInterval(long months)

quarterFromTimestamp

public static long quarterFromTimestamp(ConnectorSession session,
                                        long timestamp)

quarterFromTimestampWithTimeZone

public static long quarterFromTimestampWithTimeZone(long timestampWithTimeZone)

quarterFromDate

public static long quarterFromDate(long date)

yearFromTimestamp

public static long yearFromTimestamp(ConnectorSession session,
                                     long timestamp)

yearFromTimestampWithTimeZone

public static long yearFromTimestampWithTimeZone(long timestampWithTimeZone)

yearFromDate

public static long yearFromDate(long date)

yearFromInterval

public static long yearFromInterval(long months)

timeZoneMinuteFromTimestampWithTimeZone

public static long timeZoneMinuteFromTimestampWithTimeZone(long timestampWithTimeZone)

timeZoneHourFromTimestampWithTimeZone

public static long timeZoneHourFromTimestampWithTimeZone(long timestampWithTimeZone)

createDateTimeFormatter

public static org.joda.time.format.DateTimeFormatter createDateTimeFormatter(io.airlift.slice.Slice format)

parseDuration

public static long parseDuration(io.airlift.slice.Slice duration)

toMilliseconds

public static long toMilliseconds(long value)