convert date functions in qlikview to sql

[Anonymous]

Hi,

I want to convert the following as where calue condition which used Qlikview function into sql and run and check it sql side.

could you please help me in converting there Qlikview function into sql

(DATE(DATE#(MID(time,1,10),'YYYY-MM-DD'))>=DATE(ADDMONTHS(TODAY(),-24))) AND (DATE(DATE#(MID(time,1,10),'YYYY-MM-DD')))<=DATE(TODAY()) .

[SreeniJD]

Hi Teja

Can you clarify one thing... you want to convert the SQL from Qlikview to SQL (Oralce,MySQL) and execute the same in Oracle DB?

Sreeni

[Anonymous]

No I wanted to run a sql query from the Qlikview and I am connecting to the database database from Qlikview.

[settu_periasamy]

Hi,

May be like this..

CONVERT(TIME,GETDATE())>=DATEADD(month,-24,CURDATE()) AND

CONVERT(TIME,GETDATE())<=CURDATE()

[vincent_ardiet]

Have you tried to run my code directly on SQLServer ?