sheeri kritzer wrote:
MySQL usually gives a syntax error *where* the error happens. In this
case, it would indicate a problem with "SEC_TO_TIME(" but there
shouldn't be a problem, both according to the manual AND according to
my example.
The parser reads the query left-to-right and always qu
Mike Blezien wrote:
Hello,
this is a continued problem we are having from a earlier posting to the
list regarding a query. We need to calculate the SUM of the column
'agent_product_time' which is a TIME datatype column and according to
the manual:
http://dev.mysql.com/doc/refman/4.1/en/date-
Hi Sheeri,
Is your 'u.modified' column a TIME datatype '00:00:00'
Mike
- Original Message -
From: "sheeri kritzer" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "MySQL List"
Sent: Wednesday, May 17, 2006
Mike,
I can't really help except to ask if you're sure you copied and pasted
the query correctly. I did a similar query against a test system:
select u.uid,u.username,b.buddyUid,SEC_TO_TIME(SUM(TIME_TO_SEC(u.modified)))
as mins from Users u left join BuddyList b on u.uid = b.uid where
u.modifie
Hello,
this is a continued problem we are having from a earlier posting to the list
regarding a query. We need to calculate the SUM of the column
'agent_product_time' which is a TIME datatype column and according to the
manual:
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-type-overvie
