Search Results
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 1880; Symbol: ER_OLD_TEMPORALS_UPGRADED; SQLSTATE: HY000 Message: TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format. Error number: 4095; Symbol: ER_WARN_DEPRECATED_DATETIME_DELIMITER; SQLSTATE: HY000 ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-23.html
Also, with the implementation of the new mechanism, a getObject(columnIndex) call on a DATETIME column returns a LocalDateTime object now instead of a String. (WL #14206, WL #14274) Bugs Fixed Storing a java.time.LocalDateTime object onto the server ... Version 8.0.23 is the latest General Availability release of the 8.0 series of MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-time-zone.html
>>> cnx.time_zone = '+00:00' >>> cursor = cnx.cursor() >>> cursor.execute('SELECT NOW()') ; cursor.fetchone() (datetime.datetime(2012, 6, 15, 11, 24, 36),) >>> cnx.time_zone = '-09:00' >>> cursor.execute('SELECT NOW()') ; cursor.fetchone() ... This ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-select.html
Note that hire_date was converted automatically by Connector/Python to a Python datetime.date object. The following example shows how to query data using a cursor created using the connection's cursor() method. The task is to select all employees ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-transaction.html
We could calculate tomorrow by calling a database function, but for clarity we do it in Python using the datetime module. Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-time-zone.html
>>> cnx.time_zone = '+00:00' >>> cursor = cnx.cursor() >>> cursor.execute('SELECT NOW()') ; cursor.fetchone() (datetime.datetime(2012, 6, 15, 11, 24, 36),) >>> cnx.time_zone = '-09:00' >>> cursor.execute('SELECT NOW()') ; cursor.fetchone() ... This ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-select.html
Note that hire_date was converted automatically by Connector/Python to a Python datetime.date object. The following example shows how to query data using a cursor created using the connection's cursor() method. The task is to select all employees ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-cursor-transaction.html
We could calculate tomorrow by calling a database function, but for clarity we do it in Python using the datetime module. Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage ...
https://dev.mysql.com/doc/internals/en/date-and-time-data-type-representation.html
The following table shows the storage requirements for date and time data types. Storage for these types is big endian (for memcmp() compatibility purposes), with the nonfractional part followed by the fractional part. FSP Storage 0 0 bytes 1,2 1 ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-32.html
(Bug #108911, Bug #34773422) Using USE_TZ=True in the Django settings would raise this exception: ValueError: Not naive datetime (tzinfo is already set). (Bug #34556157) When using a prepared cursor, a DATETIME column containing 00:00:00 as the time ... Functionality Added or Changed Bugs Fixed Functionality Added or Changed Removed distutils support, which is deprecated in Python 3.10 and removed in Python ...