FormatTimeStamp in SQL Query Failing
Posted: Sun May 14, 2017 4:18 am
Hi all,
I'm trying to use the following in an SQL query - ${FormatTimestamp(${CurrentTimeMillis()}, "yyyy-MM-dd")} but get the following error -
Invalid expression for attribute 'statement' in element 'query'. Unrecognizable character '$' found at position '16'.
Does anyone know how I can escape the ${CurrentTimeMillis()} variable?
Thanks in advance,
Bode
I'm trying to use the following in an SQL query - ${FormatTimestamp(${CurrentTimeMillis()}, "yyyy-MM-dd")} but get the following error -
Invalid expression for attribute 'statement' in element 'query'. Unrecognizable character '$' found at position '16'.
Does anyone know how I can escape the ${CurrentTimeMillis()} variable?
Thanks in advance,
Bode