Documentation Home
Connectors and APIs Manual
Download this Manual Datetime types processing

  • noDatetimeStringSync

    Don't ensure that ResultSet.getDatetimeType().toString().equals(ResultSet.getString())

    Default Value false
    Since Version 3.1.7
  • sendFractionalSeconds

    Send fractional part from TIMESTAMP seconds. If set to false, the nanoseconds value of TIMESTAMP values will be truncated before sending any data to the server. This option applies only to prepared statements, callable statements or updatable result sets.

    Default Value true
    Since Version 5.1.37
  • serverTimezone

    Override detection/mapping of time zone. Used when time zone from server doesn't map to Java time zone

    Since Version 3.0.2
  • treatUtilDateAsTimestamp

    Should the driver treat java.util.Date as a TIMESTAMP for the purposes of PreparedStatement.setObject()?

    Default Value true
    Since Version 5.0.5
  • yearIsDateType

    Should the JDBC driver treat the MySQL type "YEAR" as a java.sql.Date, or as a SHORT?

    Default Value true
    Since Version 3.1.9
  • zeroDateTimeBehavior

    What should happen when the driver encounters DATETIME values that are composed entirely of zeros (used by MySQL to represent invalid dates)? Valid values are "EXCEPTION", "ROUND" and "CONVERT_TO_NULL".

    Default Value EXCEPTION
    Since Version 3.1.4