DateTimeUtils

Value Members

1. final def !=(arg0: Any): Boolean

   

   Definition Classes

   AnyRef → Any

2. final def ##(): Int

   

   Definition Classes

   AnyRef → Any

3. final def ==(arg0: Any): Boolean

   

   Definition Classes

   AnyRef → Any

4. final val JULIAN_DAY_OF_EPOCH: Int(2440588)

   

5. final val MICROS_PER_DAY: Long

   

6. final val MICROS_PER_SECOND: Long(1000000L)

   

7. final val MILLIS_PER_DAY: Long

   

8. final val MILLIS_PER_SECOND: Long(1000L)

   

9. final val MonthOf31Days: Set[Int]

   

10. final val NANOS_PER_SECOND: Long

    

11. final val SECONDS_PER_DAY: Long

    

12. val TIMEZONE_OPTION: String

    

13. final val TimeZoneGMT: TimeZone

    

14. final val YearZero: Int(-17999)

    

15. final def asInstanceOf[T0]: T0

    

    Definition Classes

    Any

16. def clone(): AnyRef

    

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

17. def convertTz(ts: SQLTimestamp, fromZone: TimeZone, toZone: TimeZone): SQLTimestamp

    

    Convert the timestamp ts from one timezone to another.

    Convert the timestamp ts from one timezone to another.

    TODO: Because of DST, the conversion between UTC and human time is not exactly one-to-one mapping, the conversion here may return wrong result, we should make the timestamp timezone-aware.

18. def dateAddMonths(days: SQLDate, months: Int): SQLDate

    

    Add date and year-month interval.

    Add date and year-month interval. Returns a date value, expressed in days since 1.1.1970.

19. def dateToString(days: SQLDate): String

    

20. final val daysIn400Years: Int

    

21. def daysToMillis(days: SQLDate, timeZone: TimeZone): Long

    

22. def daysToMillis(days: SQLDate): Long

    

23. def defaultTimeZone(): TimeZone

    

24. final def eq(arg0: AnyRef): Boolean

    

    Definition Classes

    AnyRef

25. def equals(arg0: Any): Boolean

    

    Definition Classes

    AnyRef → Any

26. def finalize(): Unit

    

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

    @throws( classOf[java.lang.Throwable] )

27. def fromJavaDate(date: Date): SQLDate

    

    Returns the number of days since epoch from java.sql.Date.

28. def fromJavaTimestamp(t: Timestamp): SQLTimestamp

    

    Returns the number of micros since epoch from java.sql.Timestamp.

29. def fromJulianDay(day: Int, nanoseconds: Long): SQLTimestamp

    

    Returns the number of microseconds since epoch from Julian day and nanoseconds in a day

30. def fromMillis(millis: Long): SQLTimestamp

    

31. def fromUTCTime(time: SQLTimestamp, timeZone: String): SQLTimestamp

    

    Returns a timestamp of given timezone from utc timestamp, with the same string representation in their timezone.

32. final def getClass(): Class[_]

    

    Definition Classes

    AnyRef → Any

33. def getDayInYear(date: SQLDate): Int

    

    Returns the 'day in year' value for the given date.

    Returns the 'day in year' value for the given date. The date is expressed in days since 1.1.1970.

34. def getDayOfMonth(date: SQLDate): Int

    

    Returns the 'day of month' value for the given date.

    Returns the 'day of month' value for the given date. The date is expressed in days since 1.1.1970.

35. def getDayOfWeekFromString(string: UTF8String): Int

    

36. def getHours(microsec: SQLTimestamp, timeZone: TimeZone): Int

    

    Returns the hour value of a given timestamp value.

    Returns the hour value of a given timestamp value. The timestamp is expressed in microseconds.

37. def getHours(microsec: SQLTimestamp): Int

    

    Returns the hour value of a given timestamp value.

    Returns the hour value of a given timestamp value. The timestamp is expressed in microseconds.

38. def getLastDayOfMonth(date: SQLDate): SQLDate

    

    Returns last day of the month for the given date.

    Returns last day of the month for the given date. The date is expressed in days since 1.1.1970.

39. def getMinutes(microsec: SQLTimestamp, timeZone: TimeZone): Int

    

    Returns the minute value of a given timestamp value.

    Returns the minute value of a given timestamp value. The timestamp is expressed in microseconds.

40. def getMinutes(microsec: SQLTimestamp): Int

    

    Returns the minute value of a given timestamp value.

    Returns the minute value of a given timestamp value. The timestamp is expressed in microseconds.

41. def getMonth(date: SQLDate): Int

    

    Returns the month value for the given date.

    Returns the month value for the given date. The date is expressed in days since 1.1.1970. January is month 1.

42. def getNextDateForDayOfWeek(startDate: SQLDate, dayOfWeek: Int): SQLDate

    

    Returns the first date which is later than startDate and is of the given dayOfWeek.

    Returns the first date which is later than startDate and is of the given dayOfWeek. dayOfWeek is an integer ranges in [0, 6], and 0 is Thu, 1 is Fri, etc,.

43. def getQuarter(date: SQLDate): Int

    

    Returns the quarter for the given date.

    Returns the quarter for the given date. The date is expressed in days since 1.1.1970.

44. def getSeconds(microsec: SQLTimestamp, timeZone: TimeZone): Int

    

    Returns the second value of a given timestamp value.

    Returns the second value of a given timestamp value. The timestamp is expressed in microseconds.

45. def getSeconds(microsec: SQLTimestamp): Int

    

    Returns the second value of a given timestamp value.

    Returns the second value of a given timestamp value. The timestamp is expressed in microseconds.

46. def getThreadLocalDateFormat(): DateFormat

    

47. def getThreadLocalTimestampFormat(timeZone: TimeZone): DateFormat

    

48. def getTimeZone(timeZoneId: String): TimeZone

    

49. def getYear(date: SQLDate): Int

    

    Returns the year value for the given date.

    Returns the year value for the given date. The date is expressed in days since 1.1.1970.

50. def hashCode(): Int

    

    Definition Classes

    AnyRef → Any

51. final def isInstanceOf[T0]: Boolean

    

    Definition Classes

    Any

52. def millisToDays(millisUtc: Long, timeZone: TimeZone): SQLDate

    

53. def millisToDays(millisUtc: Long): SQLDate

    

54. def monthsBetween(time1: SQLTimestamp, time2: SQLTimestamp, timeZone: TimeZone): Double

    

    Returns number of months between time1 and time2.

    Returns number of months between time1 and time2. time1 and time2 are expressed in microseconds since 1.1.1970.

    If time1 and time2 having the same day of month, or both are the last day of month, it returns an integer (time under a day will be ignored).

    Otherwise, the difference is calculated based on 31 days per month, and rounding to 8 digits.

55. def monthsBetween(time1: SQLTimestamp, time2: SQLTimestamp): Double

    

    Returns number of months between time1 and time2.

    Returns number of months between time1 and time2. time1 and time2 are expressed in microseconds since 1.1.1970.

    If time1 and time2 having the same day of month, or both are the last day of month, it returns an integer (time under a day will be ignored).

    Otherwise, the difference is calculated based on 31 days per month, and rounding to 8 digits.

56. final def ne(arg0: AnyRef): Boolean

    

    Definition Classes

    AnyRef

57. def newDateFormat(formatString: String, timeZone: TimeZone): DateFormat

    

58. final def notify(): Unit

    

    Definition Classes

    AnyRef

59. final def notifyAll(): Unit

    

    Definition Classes

    AnyRef

60. def parseTruncLevel(format: UTF8String): Int

    

    Returns the truncate level, could be TRUNC_YEAR, TRUNC_MONTH, or TRUNC_INVALID, TRUNC_INVALID means unsupported truncate level.

61. def splitDate(date: SQLDate): (Int, Int, Int, Int)

    

    Split date (expressed in days since 1.1.1970) into four fields: year, month (Jan is Month 1), dayInMonth, daysToMonthEnd (0 if it's last day of month).

62. def stringToDate(s: UTF8String): Option[SQLDate]

    

    Parses a given UTF8 date string to the corresponding a corresponding Int value.

    Parses a given UTF8 date string to the corresponding a corresponding Int value. The return type is Option in order to distinguish between 0 and null. The following formats are allowed:

    yyyy, yyyy-[m]m yyyy-[m]m-[d]d yyyy-[m]m-[d]d yyyy-[m]m-[d]d * yyyy-[m]m-[d]dT*

63. def stringToTime(s: String): Date

    

    Annotations

    @tailrec()

64. def stringToTimestamp(s: UTF8String, timeZone: TimeZone): Option[SQLTimestamp]

    

65. def stringToTimestamp(s: UTF8String): Option[SQLTimestamp]

    

    Parses a given UTF8 date string to the corresponding a corresponding Long value.

    Parses a given UTF8 date string to the corresponding a corresponding Long value. The return type is Option in order to distinguish between 0L and null. The following formats are allowed:

    yyyy yyyy-[m]m yyyy-[m]m-[d]d yyyy-[m]m-[d]d yyyy-[m]m-[d]d [h]h:[m]m:[s]s.[ms][ms][ms][us][us][us] yyyy-[m]m-[d]d [h]h:[m]m:[s]s.[ms][ms][ms][us][us][us]Z yyyy-[m]m-[d]d [h]h:[m]m:[s]s.[ms][ms][ms][us][us][us]-[h]h:[m]m yyyy-[m]m-[d]d [h]h:[m]m:[s]s.[ms][ms][ms][us][us][us]+[h]h:[m]m yyyy-[m]m-[d]dT[h]h:[m]m:[s]s.[ms][ms][ms][us][us][us] yyyy-[m]m-[d]dT[h]h:[m]m:[s]s.[ms][ms][ms][us][us][us]Z yyyy-[m]m-[d]dT[h]h:[m]m:[s]s.[ms][ms][ms][us][us][us]-[h]h:[m]m yyyy-[m]m-[d]dT[h]h:[m]m:[s]s.[ms][ms][ms][us][us][us]+[h]h:[m]m [h]h:[m]m:[s]s.[ms][ms][ms][us][us][us] [h]h:[m]m:[s]s.[ms][ms][ms][us][us][us]Z [h]h:[m]m:[s]s.[ms][ms][ms][us][us][us]-[h]h:[m]m [h]h:[m]m:[s]s.[ms][ms][ms][us][us][us]+[h]h:[m]m T[h]h:[m]m:[s]s.[ms][ms][ms][us][us][us] T[h]h:[m]m:[s]s.[ms][ms][ms][us][us][us]Z T[h]h:[m]m:[s]s.[ms][ms][ms][us][us][us]-[h]h:[m]m T[h]h:[m]m:[s]s.[ms][ms][ms][us][us][us]+[h]h:[m]m

66. final def synchronized[T0](arg0: ⇒ T0): T0

    

    Definition Classes

    AnyRef

67. def timestampAddInterval(start: SQLTimestamp, months: Int, microseconds: Long, timeZone: TimeZone): SQLTimestamp

    

    Add timestamp and full interval.

    Add timestamp and full interval. Returns a timestamp value, expressed in microseconds since 1.1.1970 00:00:00.

68. def timestampAddInterval(start: SQLTimestamp, months: Int, microseconds: Long): SQLTimestamp

    

    Add timestamp and full interval.

    Add timestamp and full interval. Returns a timestamp value, expressed in microseconds since 1.1.1970 00:00:00.

69. def timestampToString(us: SQLTimestamp, timeZone: TimeZone): String

    

70. def timestampToString(us: SQLTimestamp): String

    

71. final val to2001: Int(-11323)

    

72. def toJavaDate(daysSinceEpoch: SQLDate): Date

    

    Returns a java.sql.Date from number of days since epoch.

73. def toJavaTimestamp(us: SQLTimestamp): Timestamp

    

    Returns a java.sql.Timestamp from number of micros since epoch.

74. def toJulianDay(us: SQLTimestamp): (Int, Long)

    

    Returns Julian day and nanoseconds in a day from the number of microseconds

    Returns Julian day and nanoseconds in a day from the number of microseconds

    Note: support timestamp since 4717 BC (without negative nanoseconds, compatible with Hive).

75. def toMillis(us: SQLTimestamp): Long

    

76. def toString(): String

    

    Definition Classes

    AnyRef → Any

77. def toUTCTime(time: SQLTimestamp, timeZone: String): SQLTimestamp

    

    Returns a utc timestamp from a given timestamp from a given timezone, with the same string representation in their timezone.

78. final val toYearZero: Int

    

79. def truncDate(d: SQLDate, level: Int): SQLDate

    

    Returns the trunc date from original date and trunc level.

    Returns the trunc date from original date and trunc level. Trunc level should be generated using parseTruncLevel(), should only be 1 or 2.

80. final def wait(): Unit

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

81. final def wait(arg0: Long, arg1: Int): Unit

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

82. final def wait(arg0: Long): Unit

    

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )