Hi this code was originally from MSSQL query. However, I need to convert this to MYSQL query. There are syntax errors and I do not know what it means. It says there is some error in the DECLARE section. Thanks!
I reviewed tutorials, I added semi colons and other things but still no progress.
PHP Code:
DECLARE $D1 as datetime, @D2 as datetime
SET @D1 = '01/01/2001'
SET @D2 = '01/31/2002'
SELECT A.BR, A.DEALNO, A.SEQ, @D1 AS DATEFR, @D2 AS DATETO, A.CCY, A.VDATE, A.MDATE,
A.PRODTYPE, A.CCYAMT,
ADB = ( ABS(A.CCYAMT) *
CASE WHEN (A.VDATE <= @D1 AND A.MDATE > @D2) THEN (ABS(DATEDIFF(dd, @D2, @D1)))+1
WHEN (A.MDATE = @D2 AND A.VDATE < @D1) THEN ABS(DATEDIFF(dd, A.MDATE, @D1))
WHEN (A.VDATE = @D1 AND A.MDATE > @D2) THEN (ABS(DATEDIFF(dd, @D2, @D1)))+1
WHEN (A.VDATE = @D1 AND A.MDATE = @D2) THEN (ABS(DATEDIFF(dd, @D2, @D1)))
WHEN (A.VDATE >= @D1 AND A.MDATE <= @D2) THEN ABS(DATEDIFF(dd,A.MDATE,A.VDATE))
WHEN (A.MDATE > @D2 AND (A.VDATE > @D1 AND A.VDATE <= @D2)) THEN ABS(DATEDIFF(dd, @D2,A.VDATE)) + 1
WHEN (A.VDATE < @D1 AND (A.MDATE < @D2 AND A.MDATE > @D1)) THEN ABS(DATEDIFF(dd, A.MDATE,@D1))
ELSE 0 END ) / (ABS(DATEDIFF(dd, @D1, @D2))+1),
A.INTRATE, INTPAID = CASE WHEN A.MDATE > @D2 THEN 0
WHEN A.MDATE <= @D2 AND A.MDATE < @D1 THEN 0
ELSE ABS(A.CCYAMT) * A.INTRATE * ((ABS(datediff(dd,A.MDATE,A.VDATE)))/365) END ,
INTSTATUS = datediff(dd, A.MDATE, @D2),
ETERM = CASE WHEN (A.VDATE <= @D1 AND A.MDATE > @D2) THEN (ABS(DATEDIFF(dd, @D2, @D1)))+1
WHEN (A.MDATE = @D2 AND A.VDATE < @D1) THEN ABS(DATEDIFF(dd, A.MDATE, @D1))
WHEN (A.VDATE = @D1 AND A.MDATE > @D2) THEN (ABS(DATEDIFF(dd, @D2, @D1)))+1
WHEN (A.VDATE = @D1 AND A.MDATE = @D2) THEN (ABS(DATEDIFF(dd, @D2, @D1)))
WHEN (A.VDATE >= @D1 AND A.MDATE <= @D2) THEN ABS(DATEDIFF(dd,A.MDATE,A.VDATE))
WHEN (A.MDATE > @D2 AND (A.VDATE > @D1 AND A.VDATE <= @D2)) THEN ABS(DATEDIFF(dd, @D2,A.VDATE)) + 1
WHEN (A.VDATE < @D1 AND (A.MDATE < @D2 AND A.MDATE > @D1)) THEN ABS(DATEDIFF(dd, A.MDATE, @D1))
ELSE 0 END,
DIVISOR = ABS(DATEDIFF(dd, @D1, @D2))+1, B.CNO, B.SN, B.CCODE, B.CA5
FROM opicdldt.dbo.DLDT A, opicdldt.dbo.CUST B
WHERE A.MDATE > @D1
AND A.VERDATE <= @D2
AND A.VDATE <= @D2
AND (A.REVDATE > @D2 OR A.REVDATE IS NULL)
AND A.PRODTYPE = 'PS'
AND A.COST IN ('1300000000', '1210000000', '1510000000', '1810000000', '3020000000',
'1220000000', '1530000000', '1820000000', '1840000000', '1310000000',
'1520000000', '1540000000', '1830000000', '3021000000')
AND A.CNO = B.CNO
dBforums
>
MSSQL to MySQL Query Convertion
03-20-06, 04:17
Linear Mode
