incrementing DATETIME

[TheIceman5]

why you using the dat type field format, just use a big int and store the time in the 10 figure number like 1045645444 and then modify it form there and convert it into ya date into any format you want, it seems much easier to me.

[*JaH*]

make a timestamp-cell in mysql.....if you select the timestamp-field, read it like:

SELECT UNIX_TIMESTAMP(time) as epoch_time

then you can do anything you want with it

and that way you can do so much more nice and tricky mysql-features with that cell (like selecting a certain day range etc)