Now() and time function bug??

2003-06-17 Thread Lucas Heuman
Alright, I was messing around with some time functions in Mysql and ran acrossed a wierd bug. After I set starttime to now(), anytime I run another update query against the row starttime changes to a new value. Here is what I did when I noticed the bug.. Does anyone else have a problem doing

RE: Now() and time function bug??

2003-06-17 Thread Lucas Heuman
You are absolutely correct.. I did set it to timestamp by mistake! -//Lucas On Tue, 17 Jun 2003, Jennifer Goodie wrote: After I set starttime to now(), anytime I run another update query against the row starttime changes to a new value. If starttime is the timestamp data type, and the