mysql time类型对应c

#include <stdio.h>
#include <time.h>
#include <mysql.h>

void print_time(const char *time_str) {
    struct tm tm;
    strptime(time_str, "%H:%M:%S", &tm);
    char buffer[80];
    strftime(buffer, sizeof(buffer), "%Y-%m-%d %H:%M:%S", &tm);
    printf("Converted time: %s\n", buffer);
}

int main() {
    MYSQL *conn;
    MYSQL_RES *res;
    MYSQL_ROW row;

    conn = mysql_init(NULL);
    if (!mysql_real_connect(conn, "localhost", "user", "password", "database", 0, NULL, 0)) {
        fprintf(stderr, "%s\n", mysql_error(conn));
        exit(1);
    }

    if (mysql_query(conn, "SELECT time_column FROM table_name")) {
        fprintf(stderr, "%s\n", mysql_error(conn));
        exit(1);
    }

    res = mysql_use_result(conn);
    while ((row = mysql_fetch_row(res)) != NULL) {
        print_time(row[0]);
    }

    mysql_free_result(res);
    mysql_close(conn);

    return 0;
}