org.apache.paimon.utils

Class DateTimeUtils

java.lang.Object

org.apache.paimon.utils.DateTimeUtils

public class DateTimeUtils
extends Object

Utils for date time.

Field Summary

Fields

Modifier and Type	Field and Description
static int	EPOCH_JULIAN The julian date of the epoch, 1970-01-01.
static long	MILLIS_PER_DAY The number of milliseconds in a day.
static TimeZone	UTC_ZONE The UTC time zone.

Constructor Summary

Constructors

Constructor and Description
DateTimeUtils()

Method Summary

Modifier and Type	Method and Description
static Timestamp	dateToTimestampWithLocalZone(int date, TimeZone tz)
static String	formatDate(int date) Helper for CAST({date} AS VARCHAR(n)).
static String	formatLocalDateTime(java.time.LocalDateTime localDateTime, int precision) Format a LocalDateTime to yyyy-MM-dd HH:mm:ss[.nano] string.
static String	formatTimestamp(Timestamp ts, int precision)
static String	formatTimestamp(Timestamp ts, TimeZone tz, int precision)
static String	formatTimestampMillis(int time, int precision)
static Integer	parseDate(String s)
static Integer	parseTime(String v)
static Timestamp	parseTimestampData(String dateStr, int precision)
static Timestamp	parseTimestampData(String dateStr, int precision, TimeZone timeZone)
static Timestamp	timestampToTimestampWithLocalZone(Timestamp ts, TimeZone tz)
static int	timestampWithLocalZoneToDate(Timestamp ts, TimeZone tz)
static int	timestampWithLocalZoneToTime(Timestamp ts, TimeZone tz)
static Timestamp	timestampWithLocalZoneToTimestamp(Timestamp ts, TimeZone tz)
static Timestamp	timeToTimestampWithLocalZone(int time, TimeZone tz)
static int	toInternal(Date date) Converts the Java type used for UDF parameters of SQL DATE type (Date) to internal representation (int).
static int	toInternal(java.time.LocalDate date)
static int	toInternal(java.time.LocalTime time)
static Timestamp	toInternal(long millis, int nanos)
static int	toInternal(Time time) Converts the Java type used for UDF parameters of SQL TIME type (Time) to internal representation (int).
static java.time.LocalDate	toLocalDate(int date)
static java.time.LocalDateTime	toLocalDateTime(long timeMills)
static java.time.LocalDateTime	toLocalDateTime(long timeMills, java.time.ZoneId zoneId)
static java.time.LocalDateTime	toLocalDateTime(String dateStr, int precision)
static java.time.LocalTime	toLocalTime(int time)
static Date	toSQLDate(int v) Converts the internal representation of a SQL DATE (int) to the Java type used for UDF parameters (Date).
static Time	toSQLTime(int v) Converts the internal representation of a SQL TIME (int) to the Java type used for UDF parameters (Time).
static Timestamp	truncate(Timestamp ts, int precision)
static long	unixTimestamp(long ts) Returns the value of the timestamp to seconds since '1970-01-01 00:00:00' UTC.

Methods inherited from class java.lang.Object

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

Field Detail

EPOCH_JULIAN

public static final int EPOCH_JULIAN

The julian date of the epoch, 1970-01-01.

See Also:

Constant Field Values

MILLIS_PER_DAY

public static final long MILLIS_PER_DAY

The number of milliseconds in a day.

This is the modulo 'mask' used when converting TIMESTAMP values to DATE and TIME values.

See Also:

Constant Field Values

UTC_ZONE

public static final TimeZone UTC_ZONE

The UTC time zone.

Constructor Detail

DateTimeUtils

public DateTimeUtils()

Method Detail

toSQLDate

public static Date toSQLDate(int v)

Converts the internal representation of a SQL DATE (int) to the Java type used for UDF parameters (Date).

toSQLTime

public static Time toSQLTime(int v)

Converts the internal representation of a SQL TIME (int) to the Java type used for UDF parameters (Time).

toInternal

public static int toInternal(Date date)

Converts the Java type used for UDF parameters of SQL DATE type (Date) to internal representation (int).

toInternal

public static int toInternal(Time time)

Converts the Java type used for UDF parameters of SQL TIME type (Time) to internal representation (int).

Converse of toSQLTime(int).

toInternal

public static Timestamp toInternal(long millis,
                                   int nanos)

toInternal

public static int toInternal(java.time.LocalDate date)

toInternal

public static int toInternal(java.time.LocalTime time)

formatLocalDateTime

public static String formatLocalDateTime(java.time.LocalDateTime localDateTime,
                                         int precision)

Format a LocalDateTime to yyyy-MM-dd HH:mm:ss[.nano] string.

Parameters:

precision - how many digits of nanoseconds to be retained

toLocalDate

public static java.time.LocalDate toLocalDate(int date)

toLocalTime

public static java.time.LocalTime toLocalTime(int time)

parseDate

public static Integer parseDate(String s)

parseTime

public static Integer parseTime(String v)

formatTimestamp

public static String formatTimestamp(Timestamp ts,
                                     int precision)

formatTimestamp

public static String formatTimestamp(Timestamp ts,
                                     TimeZone tz,
                                     int precision)

formatTimestampMillis

public static String formatTimestampMillis(int time,
                                           int precision)

formatDate

public static String formatDate(int date)

Helper for CAST({date} AS VARCHAR(n)).

parseTimestampData

public static Timestamp parseTimestampData(String dateStr,
                                           int precision)
                                    throws java.time.DateTimeException

Throws:

java.time.DateTimeException

parseTimestampData

public static Timestamp parseTimestampData(String dateStr,
                                           int precision,
                                           TimeZone timeZone)
                                    throws java.time.DateTimeException

Throws:

java.time.DateTimeException

toLocalDateTime

public static java.time.LocalDateTime toLocalDateTime(long timeMills)

toLocalDateTime

public static java.time.LocalDateTime toLocalDateTime(long timeMills,
                                                      java.time.ZoneId zoneId)

toLocalDateTime

public static java.time.LocalDateTime toLocalDateTime(String dateStr,
                                                      int precision)

unixTimestamp

public static long unixTimestamp(long ts)

Returns the value of the timestamp to seconds since '1970-01-01 00:00:00' UTC.

timestampToTimestampWithLocalZone

public static Timestamp timestampToTimestampWithLocalZone(Timestamp ts,
                                                          TimeZone tz)

timestampWithLocalZoneToTimestamp

public static Timestamp timestampWithLocalZoneToTimestamp(Timestamp ts,
                                                          TimeZone tz)

timestampWithLocalZoneToDate

public static int timestampWithLocalZoneToDate(Timestamp ts,
                                               TimeZone tz)

timestampWithLocalZoneToTime

public static int timestampWithLocalZoneToTime(Timestamp ts,
                                               TimeZone tz)

dateToTimestampWithLocalZone

public static Timestamp dateToTimestampWithLocalZone(int date,
                                                     TimeZone tz)

timeToTimestampWithLocalZone

public static Timestamp timeToTimestampWithLocalZone(int time,
                                                     TimeZone tz)

truncate

public static Timestamp truncate(Timestamp ts,
                                 int precision)