> 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 first timestamp in the row,
it will automatically update every time you update the row. This is not a
bug, it is expected behav
n" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, 17 June, 2003 14:05
Subject: Now() and time function bug??
Alright, I was messing around with some time functions in Mysql and ran
acrossed a wierd bug.
After I set starttime to now(), an
On 17 Jun 2003 at 14:05, Lucas Heuman wrote:
> After I set starttime to now(), anytime I run another update query
> against the row starttime changes to a new value.
You don't give the structure of your table, but it appears that
you're using a TIMESTAMP column, which has automatic updating by
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 th
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 thi
sql/bychapter/manual_Reference.html#Dat
e_and_time_functions
chris
-Original Message-
From: Rekha Das [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 2:52 PM
To: '[EMAIL PROTECTED]'
Subject: Time function
What time function should I use to add 2 hou
"Rekha Das" <[EMAIL PROTECTED]> wrote:
> What time function should I use to add 2 hours to a time value I am
getting
> from the database ?
Convert the time to seconds, add 7200 seconds (2 hours), then convert back
to time format.
SELECT SEC_TO_TIME(TIME_TO_SEC(my_time_fi
What time function should I use to add 2 hours to a time value I am getting
from the database ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list