string.format

[1LoL1]

Hello, can anyone help me how i can use in this code string.format?

i mean 01:01:01 not 1:1:1 please can anyone help me?

dbExec( database, "INSERT INTO TEST ( Data, Data2, Data3, Data4 ) VALUES ( ?, ?, ?, ?)", data, data2, "["..day.."/"..month.."/"..year.."]", "["..hour..":"..min..":"..sec.."]") 

Edited November 30, 2015 by Guest

[myonlake]

function getDateTimeString( day, month, year, hour, minute, second ) 
    return ( "%04d-%02d-%02d %02d:%02d:%02d" ):format( year or 0, month or 0, day or 0, hour or 0, minute or 0, second or 0 ) 
end 

So technically you can just modify that to your needs like so:

function getDateTimeString( day, month, year, hour, minute, second ) 
    return ( "[%02d/%02d/%04d]" ):format( year or 0, month or 0, day or 0 ), ( "[%02d:%02d:%02d]" ):format( hour or 0, minute or 0, second or 0 ) 
end 
local dateString, timeString = getDateTimeString( ... ) 

[1LoL1]

function getDateTimeString( day, month, year, hour, minute, second ) 
    return ( "%04d-%02d-%02d %02d:%02d:%02d" ):format( year or 0, month or 0, day or 0, hour or 0, minute or 0, second or 0 ) 
end 

So technically you can just modify that to your needs like so:

function getDateTimeString( day, month, year, hour, minute, second ) 
    return ( "[%02d/%02d/%04d]" ):format( year or 0, month or 0, day or 0 ), ( "[%02d:%02d:%02d]" ):format( hour or 0, minute or 0, second or 0 ) 
end 
local dateString, timeString = getDateTimeString( ... ) 

Thanks but i don't know how i can use in my code..

[1LoL1]

Ok i fixed. So it's solved.