hello i need help in date and time :) os.time()

[xavierek]

hello i know os.time() give timestemp only i need time stemp only form YYYY-MONTH-DAY whats now is it i need it to collect data for chars i need save data in database and noramlad data like YYYY-MONTH-DAY its slower ... some one can help ? how to take time stemp of year month day from system clock


i need like 1279317600 its 2010-07-17 00:00:00

i know i can get os.date("%Y-%m-%d") only how it change to time stemp google dont help me ;/

and one other question its some verible onkill to get how many exp player get ?

 

[QuaS]

save it in UNIX timestamp. Easier to compare later.

 

[xavierek]

i know only i dont need H:S ... i need update database Select from xxx where data = intimestemp(now(YYYY-MM-DD))

 

[Cykotitan]

MySQL :: MySQL 5.1 Reference Manual :: 11.7 Date and Time Functions

 

[xavierek]

hmm thx i dont thing on this way i whant make all in lua xD

 

[Cykotitan]

i need like 1279317600 its 2010-07-17 00:00:00

os.time{year=2010, month=7, day=17, hour=0, min=0, sec=0}

and one other question its some verible onkill to get how many exp player get ?

no