MySQL Connector/J 9.2.0 · com.mysql.cj.util.TimeUtil

Modifier and Type	Field and Description
public static final DateTimeFormatter	DATE_FORMATTER
public static final Pattern	DATE_LITERAL_NO_DELIMITERS
public static final Pattern	DATE_LITERAL_WITH_DELIMITERS
public static final DateTimeFormatter	DATETIME_FORMATTER_NO_FRACT_NO_OFFSET
public static final DateTimeFormatter	DATETIME_FORMATTER_NO_FRACT_WITH_OFFSET
public static final DateTimeFormatter	DATETIME_FORMATTER_WITH_MILLIS_NO_OFFSET
public static final DateTimeFormatter	DATETIME_FORMATTER_WITH_NANOS_NO_OFFSET
public static final DateTimeFormatter	DATETIME_FORMATTER_WITH_NANOS_WITH_OFFSET
public static final DateTimeFormatter	DATETIME_FORMATTER_WITH_OPTIONAL_MICROS
public static final Pattern	DATETIME_LITERAL_SHORT12
public static final Pattern	DATETIME_LITERAL_SHORT14
public static final Pattern	DATETIME_LITERAL_WITH_DELIMITERS
public static final LocalDate	DEFAULT_DATE
public static final LocalTime	DEFAULT_TIME
public static final Pattern	DURATION_LITERAL_NO_DAYS
public static final Pattern	DURATION_LITERAL_WITH_DAYS
pack-priv static final TimeZone	GMT_TIMEZONE
pack-priv static final Lock	LOCK
protected static final Method	systemNanoTimeMethod
public static final DateTimeFormatter	TIME_FORMATTER_NO_FRACT_NO_OFFSET
public static final DateTimeFormatter	TIME_FORMATTER_NO_FRACT_WITH_OFFSET
public static final DateTimeFormatter	TIME_FORMATTER_WITH_NANOS_NO_OFFSET
public static final DateTimeFormatter	TIME_FORMATTER_WITH_NANOS_WITH_OFFSET
public static final DateTimeFormatter	TIME_FORMATTER_WITH_OPTIONAL_MICROS
public static final Pattern	TIME_LITERAL_SHORT2
public static final Pattern	TIME_LITERAL_SHORT4
public static final Pattern	TIME_LITERAL_SHORT6
public static final Pattern	TIME_LITERAL_WITH_DELIMITERS
private static final String	TIME_ZONE_MAPPINGS_RESOURCE
private static Properties	timeZoneMappings

Access	Constructor and Description
public	TimeUtil()

Method Summary

Modifier and Type	Method and Description
public static Timestamp	Returns: A new Timestamp object cloned from the original one and then rounded or truncated according to required fsp value adjustNanosPrecision(Timestamp an original Timestamp object, not modified by this method ts, int value in the range from 0 to 6 specifying fractional seconds precision fsp, boolean 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. serverRoundFracSecs) Return a new Timestamp object which value is adjusted according to known DATE, DATETIME or TIMESTAMP field precision.
public static LocalDateTime	Returns: A new LocalDateTime object cloned from the original one and then rounded or truncated according to required fsp value adjustNanosPrecision(LocalDateTime an original LocalDateTime object, not modified by this method x, int value in the range from 0 to 6 specifying fractional seconds precision fsp, boolean 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. serverRoundFracSecs) Return a new LocalDateTime object which value is adjusted according to known DATE, DATETIME or TIMESTAMP field precision.
public static LocalTime	adjustNanosPrecision(LocalTime x, int fsp, boolean serverRoundFracSecs)
public static Duration	adjustNanosPrecision(Duration x, int fsp, boolean serverRoundFracSecs)
public static String	Returns: fractional seconds part as a string formatNanos(int fractional seconds value nanos, int required fractional part length fsp) Return a string representation of a fractional seconds part.
public static String	Returns: fractional seconds part as a string formatNanos(int fractional seconds value nanos, int required fractional part length fsp, boolean whether to remove trailing zero characters in a fractional part after formatting truncateTrailingZeros) Return a string representation of a fractional seconds part.
private static String	getCanonicalDate(String s)
private static String	getCanonicalDateTime(String s)
private static String	getCanonicalTime(String s)
public static String	Returns: the Java timezone name for the given timezone getCanonicalTimeZone(String the 'common' timezone name timezoneStr, ExceptionInterceptor exception interceptor exceptionInterceptor) Returns the 'official' Java timezone name for the given timezone
public static long	getCurrentTimeNanosOrMillis()
public static String	getDurationString(Duration x)
public static SimpleDateFormat	Returns: `SimpleDateFormat` object getSimpleDateFormat(SimpleDateFormat existing SimpleDateFormat to use instead of creating a new one cachedSimpleDateFormat, String format pattern pattern, TimeZone `TimeZone` object replacing the default one tz) Get SimpleDateFormat with a default Calendar which TimeZone is replaced with the provided one.
public static SimpleDateFormat	Returns: `SimpleDateFormat` object getSimpleDateFormat(String format pattern pattern, Calendar `Calendar` object which clone is replacing the default Calendar cal) Get SimpleDateFormat where a default Calendar is replaced with a clone of the provided one.
public static Boolean	hasFractionalSeconds(Time t)
private static void	loadTimeZoneMappings(ExceptionInterceptor exception interceptor exceptionInterceptor) Loads a properties file that contains all kinds of time zone mappings.
public static boolean	nanoTimeAvailable()
public static Object	parseToDateTimeObject(String s, MysqlType targetMysqlType)
public static Timestamp	truncateFractionalSeconds(Timestamp timestamp)
public static Time	truncateFractionalSeconds(Time time)

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

Field Detail

DATE_FORMATTER	back to summary
public static final DateTimeFormatter DATE_FORMATTER

DATE_LITERAL_NO_DELIMITERS	back to summary
public static final Pattern DATE_LITERAL_NO_DELIMITERS

DATE_LITERAL_WITH_DELIMITERS	back to summary
public static final Pattern DATE_LITERAL_WITH_DELIMITERS

DATETIME_FORMATTER_NO_FRACT_NO_OFFSET	back to summary
public static final DateTimeFormatter DATETIME_FORMATTER_NO_FRACT_NO_OFFSET

DATETIME_FORMATTER_NO_FRACT_WITH_OFFSET	back to summary
public static final DateTimeFormatter DATETIME_FORMATTER_NO_FRACT_WITH_OFFSET

DATETIME_FORMATTER_WITH_MILLIS_NO_OFFSET	back to summary
public static final DateTimeFormatter DATETIME_FORMATTER_WITH_MILLIS_NO_OFFSET

DATETIME_FORMATTER_WITH_NANOS_NO_OFFSET	back to summary
public static final DateTimeFormatter DATETIME_FORMATTER_WITH_NANOS_NO_OFFSET

DATETIME_FORMATTER_WITH_NANOS_WITH_OFFSET	back to summary
public static final DateTimeFormatter DATETIME_FORMATTER_WITH_NANOS_WITH_OFFSET

DATETIME_FORMATTER_WITH_OPTIONAL_MICROS	back to summary
public static final DateTimeFormatter DATETIME_FORMATTER_WITH_OPTIONAL_MICROS

DATETIME_LITERAL_SHORT12	back to summary
public static final Pattern DATETIME_LITERAL_SHORT12

DATETIME_LITERAL_SHORT14	back to summary
public static final Pattern DATETIME_LITERAL_SHORT14

DATETIME_LITERAL_WITH_DELIMITERS	back to summary
public static final Pattern DATETIME_LITERAL_WITH_DELIMITERS

DEFAULT_DATE	back to summary
public static final LocalDate DEFAULT_DATE

DEFAULT_TIME	back to summary
public static final LocalTime DEFAULT_TIME

DURATION_LITERAL_NO_DAYS	back to summary
public static final Pattern DURATION_LITERAL_NO_DAYS

DURATION_LITERAL_WITH_DAYS	back to summary
public static final Pattern DURATION_LITERAL_WITH_DAYS

GMT_TIMEZONE	back to summary
pack-priv static final TimeZone GMT_TIMEZONE

LOCK	back to summary
pack-priv static final Lock LOCK

systemNanoTimeMethod	back to summary
protected static final Method systemNanoTimeMethod

TIME_FORMATTER_NO_FRACT_NO_OFFSET	back to summary
public static final DateTimeFormatter TIME_FORMATTER_NO_FRACT_NO_OFFSET

TIME_FORMATTER_NO_FRACT_WITH_OFFSET	back to summary
public static final DateTimeFormatter TIME_FORMATTER_NO_FRACT_WITH_OFFSET

TIME_FORMATTER_WITH_NANOS_NO_OFFSET	back to summary
public static final DateTimeFormatter TIME_FORMATTER_WITH_NANOS_NO_OFFSET

TIME_FORMATTER_WITH_NANOS_WITH_OFFSET	back to summary
public static final DateTimeFormatter TIME_FORMATTER_WITH_NANOS_WITH_OFFSET

TIME_FORMATTER_WITH_OPTIONAL_MICROS	back to summary
public static final DateTimeFormatter TIME_FORMATTER_WITH_OPTIONAL_MICROS

TIME_LITERAL_SHORT2	back to summary
public static final Pattern TIME_LITERAL_SHORT2

TIME_LITERAL_SHORT4	back to summary
public static final Pattern TIME_LITERAL_SHORT4

TIME_LITERAL_SHORT6	back to summary
public static final Pattern TIME_LITERAL_SHORT6

TIME_LITERAL_WITH_DELIMITERS	back to summary
public static final Pattern TIME_LITERAL_WITH_DELIMITERS

TIME_ZONE_MAPPINGS_RESOURCE	back to summary
private static final String TIME_ZONE_MAPPINGS_RESOURCE

timeZoneMappings	back to summary
private static Properties timeZoneMappings

Constructor Detail

TimeUtil	back to summary
public TimeUtil()

Method Detail

adjustNanosPrecision	back to summary
public static Timestamp adjustNanosPrecision(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:Timestamp an original Timestamp object, not modified by this method fsp:int value in the range from 0 to 6 specifying fractional seconds precision serverRoundFracSecs:boolean 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:Timestamp A new Timestamp object cloned from the original one and then rounded or truncated according to required fsp value

adjustNanosPrecision

back to summary

public static Timestamp adjustNanosPrecision(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:Timestamp: an original Timestamp object, not modified by this method
fsp:int: value in the range from 0 to 6 specifying fractional seconds precision
serverRoundFracSecs:boolean: 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:Timestamp

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

adjustNanosPrecision	back to summary
public static LocalDateTime adjustNanosPrecision(LocalDateTime x, int fsp, boolean serverRoundFracSecs) Return a new LocalDateTime object which value is adjusted according to known DATE, DATETIME or TIMESTAMP field precision. Parameters x:LocalDateTime an original LocalDateTime object, not modified by this method fsp:int value in the range from 0 to 6 specifying fractional seconds precision serverRoundFracSecs:boolean 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:LocalDateTime A new LocalDateTime object cloned from the original one and then rounded or truncated according to required fsp value

adjustNanosPrecision

back to summary

public static LocalDateTime adjustNanosPrecision(LocalDateTime x, int fsp, boolean serverRoundFracSecs)

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

Parameters

x:LocalDateTime: an original LocalDateTime object, not modified by this method
fsp:int: value in the range from 0 to 6 specifying fractional seconds precision
serverRoundFracSecs:boolean: 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:LocalDateTime

A new LocalDateTime object cloned from the original one and then rounded or truncated according to required fsp value

adjustNanosPrecision	back to summary
public static LocalTime adjustNanosPrecision(LocalTime x, int fsp, boolean serverRoundFracSecs)

adjustNanosPrecision	back to summary
public static Duration adjustNanosPrecision(Duration x, int fsp, boolean serverRoundFracSecs)

formatNanos	back to summary
public static 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:int fractional seconds value fsp:int required fractional part length Returns:String fractional seconds part as a string

formatNanos

back to summary

public static 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:int: fractional seconds value
fsp:int: required fractional part length

Returns:String

fractional seconds part as a string

formatNanos	back to summary
public static 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:int fractional seconds value fsp:int required fractional part length truncateTrailingZeros:boolean whether to remove trailing zero characters in a fractional part after formatting Returns:String fractional seconds part as a string

formatNanos

back to summary

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

Parameters

nanos:int: fractional seconds value
fsp:int: required fractional part length
truncateTrailingZeros:boolean: whether to remove trailing zero characters in a fractional part after formatting

Returns:String

fractional seconds part as a string

getCanonicalDate	back to summary
private static String getCanonicalDate(String s)

getCanonicalDateTime	back to summary
private static String getCanonicalDateTime(String s)

getCanonicalTime	back to summary
private static String getCanonicalTime(String s)

getCanonicalTimeZone	back to summary
public static String getCanonicalTimeZone(String timezoneStr, ExceptionInterceptor exceptionInterceptor) Returns the 'official' Java timezone name for the given timezone Parameters timezoneStr:String the 'common' timezone name exceptionInterceptor:ExceptionInterceptor exception interceptor Returns:String the Java timezone name for the given timezone

getCanonicalTimeZone

back to summary

public static String getCanonicalTimeZone(String timezoneStr, ExceptionInterceptor exceptionInterceptor)

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

Parameters

timezoneStr:String: the 'common' timezone name
exceptionInterceptor:ExceptionInterceptor: exception interceptor

Returns:String

the Java timezone name for the given timezone

getCurrentTimeNanosOrMillis	back to summary
public static long getCurrentTimeNanosOrMillis()

getDurationString	back to summary
public static String getDurationString(Duration x)

getSimpleDateFormat back to summary

getSimpleDateFormat	back to summary
public static SimpleDateFormat getSimpleDateFormat(SimpleDateFormat cachedSimpleDateFormat, String pattern, 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:SimpleDateFormat existing SimpleDateFormat to use instead of creating a new one pattern:String format pattern tz:TimeZone `TimeZone` object replacing the default one Returns:SimpleDateFormat `SimpleDateFormat` object

public static SimpleDateFormat getSimpleDateFormat(SimpleDateFormat cachedSimpleDateFormat, String pattern, 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:SimpleDateFormat: existing SimpleDateFormat to use instead of creating a new one
pattern:String: format pattern
tz:TimeZone: TimeZone object replacing the default one

Returns:SimpleDateFormat

SimpleDateFormat object

getSimpleDateFormat back to summary

getSimpleDateFormat	back to summary
public static SimpleDateFormat getSimpleDateFormat(String pattern, Calendar cal) Get SimpleDateFormat where a default Calendar is replaced with a clone of 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:String format pattern cal:Calendar `Calendar` object which clone is replacing the default Calendar Returns:SimpleDateFormat `SimpleDateFormat` object

public static SimpleDateFormat getSimpleDateFormat(String pattern, Calendar cal)

Get SimpleDateFormat where a default Calendar is replaced with a clone of 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:String: format pattern
cal:Calendar: Calendar object which clone is replacing the default Calendar

Returns:SimpleDateFormat

SimpleDateFormat object

hasFractionalSeconds	back to summary
public static Boolean hasFractionalSeconds(Time t)

loadTimeZoneMappings	back to summary
private static void loadTimeZoneMappings(ExceptionInterceptor exceptionInterceptor) Loads a properties file that contains all kinds of time zone mappings. Parameters exceptionInterceptor:ExceptionInterceptor exception interceptor

loadTimeZoneMappings

back to summary

private static void loadTimeZoneMappings(ExceptionInterceptor exceptionInterceptor)

Loads a properties file that contains all kinds of time zone mappings.

Parameters

exceptionInterceptor:ExceptionInterceptor: exception interceptor

nanoTimeAvailable	back to summary
public static boolean nanoTimeAvailable()

parseToDateTimeObject	back to summary
public static Object parseToDateTimeObject(String s, MysqlType targetMysqlType)

truncateFractionalSeconds	back to summary
public static Timestamp truncateFractionalSeconds(Timestamp timestamp)

truncateFractionalSeconds	back to summary
public static Time truncateFractionalSeconds(Time time)

public Class TimeUtil

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail