incrementing DATETIME
Moderators: egami, macek, gesf
-
- New php-forum User
- Posts: 28
- Joined: Tue Jan 21, 2003 9:31 pm
- Contact:
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.
[flash width=300 height=100 loop=true]http://newbieslair.baselair.com/iceman.swf[/flash]
Administrator Newbieslair http://www.newbieslair.com
Administrator Newbieslair http://www.newbieslair.com
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)
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)