com.mysql.cj.util

Class TimeUtil

java.lang.Object

com.mysql.cj.util.TimeUtil

public class TimeUtil
extends java.lang.Object

Timezone conversion routines and other time related methods

Field Summary

Fields

Modifier and Type	Field and Description
protected static java.lang.reflect.Method	systemNanoTimeMethod

Constructor Summary

Constructors

Constructor and Description
TimeUtil()

Method Summary

Modifier and Type	Method and Description
static java.sql.Timestamp	adjustTimestampNanosPrecision(java.sql.Timestamp ts, int fsp, boolean serverRoundFracSecs) Return a new Timestamp object which value is adjusted according to known DATE, DATETIME or TIMESTAMP field precision.
static java.lang.String	formatNanos(int nanos, int fsp) Return a string representation of a fractional seconds part.
static java.lang.String	formatNanos(int nanos, int fsp, boolean truncateTrailingZeros) Return a string representation of a fractional seconds part.
static java.lang.String	getCanonicalTimezone(java.lang.String timezoneStr, ExceptionInterceptor exceptionInterceptor) Returns the 'official' Java timezone name for the given timezone
static long	getCurrentTimeNanosOrMillis()
static java.lang.String	getDateTimePattern(java.lang.String dt, boolean toTime) Used in prepared statements
static java.text.SimpleDateFormat	getSimpleDateFormat(java.text.SimpleDateFormat cachedSimpleDateFormat, java.lang.String pattern, java.util.TimeZone tz) Get SimpleDateFormat with a default Calendar which TimeZone is replaced with the provided one.
static java.text.SimpleDateFormat	getSimpleDateFormat(java.lang.String pattern, java.util.Calendar cal) Get SimpleDateFormat where a default Calendar is replaced with the provided one.
static boolean	nanoTimeAvailable()
static java.sql.Timestamp	truncateFractionalSeconds(java.sql.Timestamp timestamp)

Methods inherited from class java.lang.Object

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

Field Detail

systemNanoTimeMethod

protected static final java.lang.reflect.Method systemNanoTimeMethod

Constructor Detail

TimeUtil

public TimeUtil()

Method Detail

nanoTimeAvailable

public static boolean nanoTimeAvailable()

getCurrentTimeNanosOrMillis

public static long getCurrentTimeNanosOrMillis()

getCanonicalTimezone

public static java.lang.String getCanonicalTimezone(java.lang.String timezoneStr,
                                                    ExceptionInterceptor exceptionInterceptor)

Returns the 'official' Java timezone name for the given timezone

Parameters:

timezoneStr - the 'common' timezone name

exceptionInterceptor - exception interceptor

Returns:

the Java timezone name for the given timezone

adjustTimestampNanosPrecision

public static java.sql.Timestamp adjustTimestampNanosPrecision(java.sql.Timestamp ts,
                                                               int fsp,
                                                               boolean serverRoundFracSecs)

Return a new Timestamp object which value is adjusted according to known DATE, DATETIME or TIMESTAMP field precision.

Parameters:

ts - an original Timestamp object, not modified by this method

fsp - value in the range from 0 to 6 specifying fractional seconds precision

serverRoundFracSecs - Flag indicating whether rounding or truncation occurs on server when inserting a TIME, DATE, or TIMESTAMP value with a fractional seconds part into a column having the same type but fewer fractional digits: true means rounding, false means truncation. The proper value should be detected by analyzing sql_mode server variable for TIME_TRUNCATE_FRACTIONAL presence.

Returns:

A new Timestamp object cloned from original ones and then rounded or truncated according to required fsp value

formatNanos

public static java.lang.String formatNanos(int nanos,
                                           int fsp)

Return a string representation of a fractional seconds part. This method assumes that all Timestamp adjustments are already done before, thus no rounding is needed, only a proper "0" padding to be done.

Parameters:

nanos - fractional seconds value

fsp - required fractional part length

Returns:

fractional seconds part as a string

formatNanos

public static java.lang.String formatNanos(int nanos,
                                           int fsp,
                                           boolean truncateTrailingZeros)

Return a string representation of a fractional seconds part. This method assumes that all Timestamp adjustments are already done before, thus no rounding is needed, only a proper "0" padding to be done.

Parameters:

nanos - fractional seconds value

fsp - required fractional part length

truncateTrailingZeros - whether to remove trailing zero characters in a fractional part after formatting

Returns:

fractional seconds part as a string

truncateFractionalSeconds

public static java.sql.Timestamp truncateFractionalSeconds(java.sql.Timestamp timestamp)

getSimpleDateFormat

public static java.text.SimpleDateFormat getSimpleDateFormat(java.text.SimpleDateFormat cachedSimpleDateFormat,
                                                             java.lang.String pattern,
                                                             java.util.TimeZone tz)

Get SimpleDateFormat with a default Calendar which TimeZone is replaced with the provided one.

Note: The SimpleDateFormat object returned by this method contains a default Calendar with an altered TimeZone. It's safe to cache it between this method calls because the Calendar object itself is not altered.

Parameters:

cachedSimpleDateFormat - existing SimpleDateFormat to use instead of creating a new one

pattern - format pattern

tz - TimeZone object replacing the default one

Returns:

SimpleDateFormat object

getSimpleDateFormat

public static java.text.SimpleDateFormat getSimpleDateFormat(java.lang.String pattern,
                                                             java.util.Calendar cal)

Get SimpleDateFormat where a default Calendar is replaced with the provided one.

Note: Don't cache the SimpleDateFormat object returned by this method. Other methods could rely on assumption that the cached SimpleDateFormat has a default Calendar and that it is safe to change only it's time zone (see getSimpleDateFormat(SimpleDateFormat, String, TimeZone).

Parameters:

pattern - format pattern

cal - Calendar object replacing the default one

Returns:

SimpleDateFormat object

getDateTimePattern

public static final java.lang.String getDateTimePattern(java.lang.String dt,
                                                        boolean toTime)
                                                 throws java.io.IOException

Used in prepared statements

Parameters:

dt - DateTime string

toTime - true if get Time pattern

Returns:

pattern

Throws:

java.io.IOException - if an error occurs