Use of parameter in DATEPART in SQL query

[Lionia1979]

Hi

 

I have a jasper report fetching data with following query:

 

SELECT datepart(ww, LOGDATE) AS weeks from mc_logs

 

This works. The problem comes when I replace the 'ww' with a parameter like

 

SELECT datepart($P{DATETYPE}, LOGDATE) AS weeks from mc_logs

 

Has anyone tried this or have a workaround?

[nipo]

I was looking for the same thing... found another thread and this works for me now...

 

SELECT a,b,c,d

FROM table_t

WHERE create_timestamp <= DATE('$P!{parameterName}') AND create_timestamp > (DATE('$P!{parameterName}')-INTERVAL '6 days')

ORDER BY a

 

[This is PostgreSQL SQL]

 

For me the trick was to add the '!' mark

$P!{ParameterName}

 

I trust this to be of assistance!

have a great day!

NiPo.:silly:

[Lionia1979]

Wuawww... it worked!!!:woohoo:

Thank you for your tip.