Package org.apache.drill.exec.vector

Class DateUtilities

java.lang.Object

org.apache.drill.exec.vector.DateUtilities

public class DateUtilities
extends Object

Utility class for Date, DateTime, TimeStamp, Interval data types.

WARNING: This class is included from the JDBC driver. There is another, similar class called org.apache.drill.exec.expr.fn.impl.DateUtility. If vectors refer to that class, they will fail when called from JDBC. So, place code here if it is needed by JDBC, in the other class if only needed by the Drill engine. (This is a very poor design, but it is what it is.)

Field Summary

Fields

Modifier and Type	Field	Description
static final int	daysToStandardMillis
static final int	daysToWeeks
static final int	hoursToMillis
static final int	minutesToMillis
static final long	monthsToMillis
static final int	monthToStandardDays
static final int	secondsToMillis
static final int	yearsToMonths
static final int	yearsToQuarter

Constructor Summary

Constructors

Constructor	Description
DateUtilities()

Method Summary

Modifier and Type	Method	Description
static String	asTwoDigits(int value)
static LocalDate	fromDrillDate(long value)
static LocalTime	fromDrillTime(int value)
static Instant	fromDrillTimestamp(long value)
static org.joda.time.Period	fromInterval(int months, int days, int millis)
static org.joda.time.Period	fromIntervalDay(int days, int millis)
static org.joda.time.Period	fromIntervalYear(int value)
static StringBuilder	intervalDayStringBuilder(int days, int millis)
static StringBuilder	intervalDayStringBuilder(org.joda.time.Period value)
static StringBuilder	intervalStringBuilder(int months, int days, int millis)
static StringBuilder	intervalStringBuilder(org.joda.time.Period value)
static StringBuilder	intervalYearStringBuilder(int months)
static StringBuilder	intervalYearStringBuilder(org.joda.time.Period value)
static int	monthsFromPeriod(org.joda.time.Period period)
static int	periodToMillis(org.joda.time.Period period)
static int	periodToMonths(org.joda.time.Period value)
static String	pluralify(String term, int value)
static int	timeToMillis(int hours, int minutes, int seconds, int millis)
static long	toDrillDate(LocalDate localDate)
static int	toDrillTime(LocalTime localTime)	Convert from Java LocalTime to the ms-since-midnight format which Drill uses
static long	toDrillTimestamp(Instant instant)
static int	toMonths(int years, int months)

Methods inherited from class java.lang.Object

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

Field Details

yearsToMonths

public static final int yearsToMonths

See Also:

• Constant Field Values

yearsToQuarter

public static final int yearsToQuarter

See Also:

• Constant Field Values

daysToWeeks

public static final int daysToWeeks

See Also:

• Constant Field Values

hoursToMillis

public static final int hoursToMillis

See Also:

• Constant Field Values

minutesToMillis

public static final int minutesToMillis

See Also:

• Constant Field Values

secondsToMillis

public static final int secondsToMillis

See Also:

• Constant Field Values

monthToStandardDays

public static final int monthToStandardDays

See Also:

• Constant Field Values

monthsToMillis

public static final long monthsToMillis

See Also:

• Constant Field Values

daysToStandardMillis

public static final int daysToStandardMillis

See Also:

• Constant Field Values

Constructor Details

DateUtilities

public DateUtilities()

Method Details

monthsFromPeriod

public static int monthsFromPeriod(org.joda.time.Period period)

periodToMillis

public static int periodToMillis(org.joda.time.Period period)

toMonths

public static int toMonths(int years,
 int months)

periodToMonths

public static int periodToMonths(org.joda.time.Period value)

fromIntervalYear

public static org.joda.time.Period fromIntervalYear(int value)

intervalYearStringBuilder

public static StringBuilder intervalYearStringBuilder(int months)

intervalYearStringBuilder

public static StringBuilder intervalYearStringBuilder(org.joda.time.Period value)

pluralify

public static String pluralify(String term,
 int value)

fromIntervalDay

public static org.joda.time.Period fromIntervalDay(int days,
 int millis)

intervalDayStringBuilder

public static StringBuilder intervalDayStringBuilder(int days,
 int millis)

intervalDayStringBuilder

public static StringBuilder intervalDayStringBuilder(org.joda.time.Period value)

fromInterval

public static org.joda.time.Period fromInterval(int months,
 int days,
 int millis)

asTwoDigits

public static String asTwoDigits(int value)

intervalStringBuilder

public static StringBuilder intervalStringBuilder(int months,
 int days,
 int millis)

intervalStringBuilder

public static StringBuilder intervalStringBuilder(org.joda.time.Period value)

timeToMillis

public static int timeToMillis(int hours,
 int minutes,
 int seconds,
 int millis)

toDrillTime

public static int toDrillTime(LocalTime localTime)

Convert from Java LocalTime to the ms-since-midnight format which Drill uses

Parameters:

localTime - Java local time

Returns:

Drill form of the time

fromDrillTime

public static LocalTime fromDrillTime(int value)

toDrillDate

public static long toDrillDate(LocalDate localDate)

fromDrillDate

public static LocalDate fromDrillDate(long value)

toDrillTimestamp

public static long toDrillTimestamp(Instant instant)

fromDrillTimestamp

public static Instant fromDrillTimestamp(long value)