FormatTimeStamp in SQL Query Failing
Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
1 post
Page 1 of 1
- Posts: 1
- Joined: Sun Mar 12, 2017 6:25 pm
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
1 post
Page 1 of 1