Convert SQL query to Mysql

[Akshay malvankar]

I have following query in SQL

Select CONVERT(nvarchar(;4), t/60) + '.' + CONVERT(nvarchar(4), t % 60) as t
         from (SELECT avg(TIMESTAMPDIFF(second,tur.start,tur.[end])) as t FROM tblUserTracking tur where tur.start
         between DATE_FORMAT(p_FromDt,'%m/%d/%Y')
         and TIMESTAMPADD(DAY,1,DATE_FORMAT(p_Todt,'%m/%d/%Y')) ) as tbl1

Now I want to convert it into Mysql, so anybody help on this

I try this query also

Select CONCAT(FLOOR(t / 60), '.', MOD(t, 60)) as t
         from (SELECT avg(TIMESTAMPDIFF(second,tur.start,tur.[end])) as t 
         FROM tblUserTracking tur where tur.start
         between DATE_FORMAT(p_FromDt,'%m/%d/%Y')
         and TIMESTAMPADD(DAY,1,DATE_FORMAT(p_Todt,'%m/%d/%Y')) ) as tbl1

It give me error on line select

select is not valid at this position for this server position excepting : '( ' with

[Zeeshan iqbal]

from (SELECT avg(TIMESTAMPDIFF(second,tur.start,tur.[end])) as t 
         FROM tblUserTracking tur where tur.start

Why you use 2 from in select also if you want to do add a left join