TimeUtil (aws-mysql-jdbc 1.1.0 API)

java.lang.Object
- com.mysql.cj.util.TimeUtil

```
public class TimeUtil
extends java.lang.Object
```
Time zone conversion routines and other time related methods

Field Summary

Fields
Modifier and Type	Field and Description
`static java.time.format.DateTimeFormatter`	`DATE_FORMATTER`
`static java.util.regex.Pattern`	`DATE_LITERAL_NO_DELIMITERS`
`static java.util.regex.Pattern`	`DATE_LITERAL_WITH_DELIMITERS`
`static java.time.format.DateTimeFormatter`	`DATETIME_FORMATTER_NO_FRACT_NO_OFFSET`
`static java.time.format.DateTimeFormatter`	`DATETIME_FORMATTER_NO_FRACT_WITH_OFFSET`
`static java.time.format.DateTimeFormatter`	`DATETIME_FORMATTER_WITH_MILLIS_NO_OFFSET`
`static java.time.format.DateTimeFormatter`	`DATETIME_FORMATTER_WITH_NANOS_NO_OFFSET`
`static java.time.format.DateTimeFormatter`	`DATETIME_FORMATTER_WITH_NANOS_WITH_OFFSET`
`static java.util.regex.Pattern`	`DATETIME_LITERAL_SHORT12`
`static java.util.regex.Pattern`	`DATETIME_LITERAL_SHORT14`
`static java.util.regex.Pattern`	`DATETIME_LITERAL_WITH_DELIMITERS`
`static java.util.regex.Pattern`	`DURATION_LITERAL_NO_DAYS`
`static java.util.regex.Pattern`	`DURATION_LITERAL_WITH_DAYS`
`protected static java.lang.reflect.Method`	`systemNanoTimeMethod`
`static java.time.format.DateTimeFormatter`	`TIME_FORMATTER_NO_FRACT_NO_OFFSET`
`static java.time.format.DateTimeFormatter`	`TIME_FORMATTER_NO_FRACT_WITH_OFFSET`
`static java.time.format.DateTimeFormatter`	`TIME_FORMATTER_WITH_NANOS_NO_OFFSET`
`static java.time.format.DateTimeFormatter`	`TIME_FORMATTER_WITH_NANOS_WITH_OFFSET`
`static java.util.regex.Pattern`	`TIME_LITERAL_SHORT2`
`static java.util.regex.Pattern`	`TIME_LITERAL_SHORT4`
`static java.util.regex.Pattern`	`TIME_LITERAL_SHORT6`
`static java.util.regex.Pattern`	`TIME_LITERAL_WITH_DELIMITERS`

Constructor Summary

Constructors
Constructor and Description

TimeUtil()

Constructors
Constructor and Description
`TimeUtil()`

Method Summary

All Methods Static Methods Concrete Methods
Modifier and Type	Method and Description
`static java.time.Duration`	`adjustNanosPrecision(java.time.Duration x, int fsp, boolean serverRoundFracSecs)`
`static java.time.LocalDateTime`	`adjustNanosPrecision(java.time.LocalDateTime x, int fsp, boolean serverRoundFracSecs)` Return a new LocalDateTime object which value is adjusted according to known DATE, DATETIME or TIMESTAMP field precision.
`static java.time.LocalTime`	`adjustNanosPrecision(java.time.LocalTime x, int fsp, boolean serverRoundFracSecs)`
`static java.sql.Timestamp`	`adjustNanosPrecision(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`	`getDurationString(java.time.Duration x)`
`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 a clone of the provided one.
`static java.lang.Boolean`	`hasFractionalSeconds(java.sql.Time t)`
`static boolean`	`nanoTimeAvailable()`
`static java.lang.Object`	`parseToDateTimeObject(java.lang.String s, MysqlType targetMysqlType)`
`static java.sql.Time`	`truncateFractionalSeconds(java.sql.Time time)`
`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
  - DATE_FORMATTER
```
public static final java.time.format.DateTimeFormatter DATE_FORMATTER
```
  - TIME_FORMATTER_NO_FRACT_NO_OFFSET
```
public static final java.time.format.DateTimeFormatter TIME_FORMATTER_NO_FRACT_NO_OFFSET
```
  - TIME_FORMATTER_WITH_NANOS_NO_OFFSET
```
public static final java.time.format.DateTimeFormatter TIME_FORMATTER_WITH_NANOS_NO_OFFSET
```
  - TIME_FORMATTER_NO_FRACT_WITH_OFFSET
```
public static final java.time.format.DateTimeFormatter TIME_FORMATTER_NO_FRACT_WITH_OFFSET
```
  - TIME_FORMATTER_WITH_NANOS_WITH_OFFSET
```
public static final java.time.format.DateTimeFormatter TIME_FORMATTER_WITH_NANOS_WITH_OFFSET
```
  - DATETIME_FORMATTER_NO_FRACT_NO_OFFSET
```
public static final java.time.format.DateTimeFormatter DATETIME_FORMATTER_NO_FRACT_NO_OFFSET
```
  - DATETIME_FORMATTER_WITH_MILLIS_NO_OFFSET
```
public static final java.time.format.DateTimeFormatter DATETIME_FORMATTER_WITH_MILLIS_NO_OFFSET
```
  - DATETIME_FORMATTER_WITH_NANOS_NO_OFFSET
```
public static final java.time.format.DateTimeFormatter DATETIME_FORMATTER_WITH_NANOS_NO_OFFSET
```
  - DATETIME_FORMATTER_NO_FRACT_WITH_OFFSET
```
public static final java.time.format.DateTimeFormatter DATETIME_FORMATTER_NO_FRACT_WITH_OFFSET
```
  - DATETIME_FORMATTER_WITH_NANOS_WITH_OFFSET
```
public static final java.time.format.DateTimeFormatter DATETIME_FORMATTER_WITH_NANOS_WITH_OFFSET
```
  - DATE_LITERAL_WITH_DELIMITERS
```
public static final java.util.regex.Pattern DATE_LITERAL_WITH_DELIMITERS
```
  - DATE_LITERAL_NO_DELIMITERS
```
public static final java.util.regex.Pattern DATE_LITERAL_NO_DELIMITERS
```
  - TIME_LITERAL_WITH_DELIMITERS
```
public static final java.util.regex.Pattern TIME_LITERAL_WITH_DELIMITERS
```
  - TIME_LITERAL_SHORT6
```
public static final java.util.regex.Pattern TIME_LITERAL_SHORT6
```
  - TIME_LITERAL_SHORT4
```
public static final java.util.regex.Pattern TIME_LITERAL_SHORT4
```
  - TIME_LITERAL_SHORT2
```
public static final java.util.regex.Pattern TIME_LITERAL_SHORT2
```
  - DATETIME_LITERAL_WITH_DELIMITERS
```
public static final java.util.regex.Pattern DATETIME_LITERAL_WITH_DELIMITERS
```
  - DATETIME_LITERAL_SHORT14
```
public static final java.util.regex.Pattern DATETIME_LITERAL_SHORT14
```
  - DATETIME_LITERAL_SHORT12
```
public static final java.util.regex.Pattern DATETIME_LITERAL_SHORT12
```
  - DURATION_LITERAL_WITH_DAYS
```
public static final java.util.regex.Pattern DURATION_LITERAL_WITH_DAYS
```
  - DURATION_LITERAL_NO_DAYS
```
public static final java.util.regex.Pattern DURATION_LITERAL_NO_DAYS
```
  - 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
  - adjustNanosPrecision
```
public static java.sql.Timestamp adjustNanosPrecision(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 the original one and then rounded or truncated according to required fsp value
  - adjustNanosPrecision
```
public static java.time.LocalDateTime adjustNanosPrecision(java.time.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 - an original LocalDateTime 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 LocalDateTime object cloned from the original one and then rounded or truncated according to required fsp value
  - adjustNanosPrecision
```
public static java.time.LocalTime adjustNanosPrecision(java.time.LocalTime x,
                                                       int fsp,
                                                       boolean serverRoundFracSecs)
```
  - adjustNanosPrecision
```
public static java.time.Duration adjustNanosPrecision(java.time.Duration x,
                                                      int fsp,
                                                      boolean serverRoundFracSecs)
```
  - 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)
```
  - truncateFractionalSeconds
```
public static java.sql.Time truncateFractionalSeconds(java.sql.Time time)
```
  - hasFractionalSeconds
```
public static java.lang.Boolean hasFractionalSeconds(java.sql.Time t)
```
  - 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 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 - format pattern
    
    cal - Calendar object which clone is replacing the default Calendar
    
    Returns:
    
    SimpleDateFormat object
  - parseToDateTimeObject
```
public static java.lang.Object parseToDateTimeObject(java.lang.String s,
                                                     MysqlType targetMysqlType)
                                              throws java.io.IOException
```
    Throws:
    
    java.io.IOException
  - getDurationString
```
public static java.lang.String getDurationString(java.time.Duration x)
```

Class TimeUtil

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

DATE_FORMATTER

TIME_FORMATTER_NO_FRACT_NO_OFFSET

TIME_FORMATTER_WITH_NANOS_NO_OFFSET

TIME_FORMATTER_NO_FRACT_WITH_OFFSET

TIME_FORMATTER_WITH_NANOS_WITH_OFFSET

DATETIME_FORMATTER_NO_FRACT_NO_OFFSET

DATETIME_FORMATTER_WITH_MILLIS_NO_OFFSET

DATETIME_FORMATTER_WITH_NANOS_NO_OFFSET

DATETIME_FORMATTER_NO_FRACT_WITH_OFFSET

DATETIME_FORMATTER_WITH_NANOS_WITH_OFFSET

DATE_LITERAL_WITH_DELIMITERS

DATE_LITERAL_NO_DELIMITERS

TIME_LITERAL_WITH_DELIMITERS

TIME_LITERAL_SHORT6

TIME_LITERAL_SHORT4

TIME_LITERAL_SHORT2

DATETIME_LITERAL_WITH_DELIMITERS

DATETIME_LITERAL_SHORT14

DATETIME_LITERAL_SHORT12

DURATION_LITERAL_WITH_DAYS

DURATION_LITERAL_NO_DAYS

systemNanoTimeMethod

Constructor Detail

TimeUtil

Method Detail

nanoTimeAvailable

getCurrentTimeNanosOrMillis

getCanonicalTimeZone

adjustNanosPrecision

adjustNanosPrecision

adjustNanosPrecision

adjustNanosPrecision

formatNanos

formatNanos

truncateFractionalSeconds

truncateFractionalSeconds

hasFractionalSeconds

getSimpleDateFormat

getSimpleDateFormat

parseToDateTimeObject

getDurationString