Listing 7. Using CURRENT_TIME()

int main(int argc, char **argv)
{
    sqlite *db;

    sqlite* db = sqlite_open(argv[1], 770);

    sqlite_create_function(db,
                           "CURRENT_TIME",0,
                           current_time,NULL);

    sqlite_exec(db, "select CURRENT_TIME()",
                callback_fn);

    sqlite_close(db);

    return 0;
}