MYSQL Select query to HANA database select query

387 Views

Hi HANA experts,

Kindly help me in converting the below MYSQL database sepecific query to HANA database query

select [MATERIAL], [PLANT], [COSTSTATUS], [COSTVAR],

convert(char,min(DATEFROM),112) min_datefrom,

[COMP_CODE],
[CCOMPSTRUC],

convert(char,max(DATETO),112) max_dateto

from (SELECT [MATERIAL], [PLANT], [COSTSTATUS],

[COSTVAR],[COMP_CODE], [CCOMPSTRUC],

convert(datetime, [DATEFROM],112) DATEFROM ,

convert(datetime, [DATETO] ,112) DATETO,

convert( integer,

convert(datetime, [DATETO],112) -

convert(datetime , [DATEFROM],112))+ 1 LP

FROM [TABLE_NAME] as t1 with (nolock)

where [COSTSTATUS] = 'FR'

and (t1.[COSTVAR] = 'GSTD' or

t1.[COSTVAR] = 'LSTD')

and CCOMPSTRUC >= '03'

and DATETO <> '99991231'

and DATETO <> '00000000'

and DATEFROM <> '00000000') as q

group by [MATERIAL], [PLANT], [COSTSTATUS], [COSTVAR],

[COMP_CODE], [CCOMPSTRUC]

having convert( integer, max(DATETO) -

min(DATEFROM) )+1 > sum(LP).

I am new to both mysql and hana. Help is very much appreciated.