Home > Article > Backend Development > A complete list of recommended time-related functions
The binary protocol allows you to send and receive date and time values (DATE, TIME, DATETIME, and TIMESTAMP) using the MYSQL_TIME structure. The members of this structure are described in Section 25.2.5, “Data Types for C API Prepared Statements”. To send temporary data values, use mysql_stmt_prepare() to create prepared statements. Then, before calling mysql_stmt_execute() to execute the statement, you can use the following steps to set each temporary parameter: In the MYSQL_BIND structure associated with the data value, set the buffer_type member to the corresponding type, which specifies the type of temporary value sent . For DATE, TIME, DATETIME, or TIMESTAMP values, set buffer_type to MYSQL_TYPE_DATE, MYSQL_TYPE_TIME, MYSQL_TYPE_DATETIME, or MYSQL_TYPE_TIMESTAMP respectively. Set the buffer member of the MYSQL_BIND structure to be used to pass the temporary
1. Time-related functions for getting started with MySQL
Introduction: The binary protocol allows you to send and receive date and time values (DATE, TIME, DATETIME, and TIMESTAMP) using the MYSQL_TIME structure. The members of this structure are described in Section 25.2.5, “Data Types for C API Prepared Statements”.
2. php date and time related functions
##Introduction: Complete collection of date and time related functions in PHP extensions
The above is the detailed content of A complete list of recommended time-related functions. For more information, please follow other related articles on the PHP Chinese website!