Thread: mySQL Datetime

Hi,

How do you store and use an MySQL datetime variable in C?

I can save it as a time_t variable, and if I do a printf using %s I can print it, and it looks like it should. But I want to compare the time between now and the time I get from my mySQL DB.

If I use printf and %d, I only get 5 digits compared to 6 for my now value I create with time(NULL). And my DB dates are only a couple of days old (this after I have divided with 3600 to get it in hours instead of seconds).

/Mattias

Following calling time(), you need to use localtime() to get a 'struct tm', then use strftime() to format a time string.