No cache version.
Caching disabled. Default setting for this page:enabled (code DEF204)If the display is too slow, you can disable the user mode to view the cached version.
Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/date-and-time-functions.html
DATETIME if the first argument is a DATETIME (or TIMESTAMP) value, or if the first argument is a DATE and the unit value uses HOURS, MINUTES, or SECONDS. mysql> SELECT DATE_FORMAT('2003-10-03',GET_FORMAT(DATE,'EUR')); -> '03.10.2003' mysql> SELECT ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/expressions.html
unit represents the unit for interpreting the quantity; it is a specifier such as HOUR, DAY, or WEEK. For example, if you specify a unit of DAY_SECOND, the value of expr is expected to have days, hours, minutes, and seconds parts. If you specify a ... This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in ...
https://dev.mysql.com/user-resources.html
The value for each per-hour limit should be an integer representing a count per hour. The following statement changes the query limit for francis to 100: mysql> ALTER USER 'francis'@'localhost' WITH MAX_QUERIES_PER_HOUR 100; The statement modifies ... One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...
https://dev.mysql.com/create-event.html
This is an example of a minimal CREATE EVENT statement: CREATE EVENT myevent ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO UPDATE myschema.mytable SET mycol = mycol + 1; The previous statement creates an event named myevent. This event ...
https://dev.mysql.com/alter-event.html
ALTER [DEFINER = user] EVENT event_name [ON SCHEDULE schedule] [ON COMPLETION [NOT] PRESERVE] [RENAME TO new_event_name] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] [DO event_body] The ALTER EVENT statement changes one or more of the ...
https://dev.mysql.com/time.html
MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large because the TIME type can be used not only to represent a time of day (which must be less than 24 hours), ...MySQL recognizes TIME values in several formats, some of which can include a trailing fractional seconds part in up to microseconds (6 digits) ...
https://dev.mysql.com/c-api-prepared-statement-data-structures.html
The hour, minute, and second elements are used for TIME, DATETIME, and TIMESTAMP values. Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer ...
https://dev.mysql.com/faqs-replication.html
The slave can go down or stay disconnected for hours or even days, and then reconnect and catch up on updates. Note that if your slave has been disconnected from the master for one hour, and then reconnects, you may immediately see large Time values ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/func-op-summary-ref.html
GTID_SUBTRACT() Return all GTIDs in set that are not in subset. JSON_CONTAINS() Whether JSON document contains specific object at path JSON_CONTAINS_PATH() Whether JSON document contains any data at path JSON_DEPTH() Maximum depth of JSON document ...
https://dev.mysql.com/date-and-time-literals.html
Similarly, for values specified as strings that include time part delimiters, it is unnecessary to specify two digits for hour, minute, or second values that are less than 10. The string is interpreted from left to right to find year, month, day, ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-hour-p-1.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
