[StrikerZ]

Is there a way to save seconds in a time format for example :

PHP Code:

day:hours:seconds 


in mysql ?

[iGetty]

Yeah, use "gettime", EG:

PHP Code:

new str[20], time[3];
gettime(time[0], time[1], time[2]);
format(str, sizeof(str), "%i:%i:%i", time[0], time[1], time[2]); 


Then insert it into the DB as a string (Make sure the table settings for that column is a VARCHAR).

[StrikerZ]

Quote:

Originally Posted by iGetty Yeah, use "gettime", EG: PHP Code: new str[20], time[3]; gettime(time[0], time[1], time[2]); format(str, sizeof(str), "%i:%i:%i", time[0], time[1], time[2]);  Then insert it into the DB as a string (Make sure the table settings for that column is a VARCHAR).

Well I had a variable with seconds stored in it. Wanted to convert it to that format.

[Vince]

https://dev.mysql.com/doc/refman/5.5...on_sec-to-time