谁帮我把下面的sql server的语句换成支持mysql的
1、
UPDATE Record
SET OverTime = (CASE WHEN
DATEDIFF(D,
CAST((CONVERT(CHAR(11),BeginDate,120 )
+ CONVERT(CHAR(8),BeginTime,108)) AS DATETIME) ,
CAST((CONVERT(CHAR(11),EndDate ,120 )
+ CONVERT(CHAR(8),EndTime ,108)) AS DATETIME))
> PrescribeTime
THEN 1 ELSE 0 END)
2、
--SELECT * FROM CALC
DECLARE @S VARCHAR(8000)
SET @S = ''
SELECT @S = @S + (SELECT JSGS FROM CALC WHERE autoid = 1)
+ '+(CASE WHEN a.OverTime = 1 THEN '
+ (SELECT JSGS FROM CALC WHERE autoid = 2)
+ ' ELSE 0 END)'
SET @S ='SELECT
a.autoid,
a.CarID,
a.DriverID,
a.WorkerID,
'+@S+'+ISNULL(SUM(B.money),0) as Money
FROM
(SELECT *,
DATEDIFF(D,
CAST((CONVERT(CHAR(11),BeginDate,120 )
+ CONVERT(CHAR(8),BeginTime,108)) AS DATETIME) ,
CAST((CONVERT(CHAR(11),EndDate ,120 )
+ CONVERT(CHAR(8),EndTime ,108)) AS DATETIME)) - PrescribeTime AS RunTime
FROM Record) a
LEFT JOIN
MoneyDef b
ON
a.autoid = b.runcarid
GROUP BY
a.autoid,
a.RunTime,
a.RunLong,
a.OverTime,
a.CarID,
a.DriverID,
a.WorkerID'
EXEC(@S)