"Access or violation" error using timestamp with OracleTag(s): Common problems


Using the ODBC escape sequence {ts to represent a timestamp value, you may receive the error "Access violation" if your query looks like
{ ts '2003-03-25 00:00:00' }
With Oracle, you have to add the milliseconds part. So use this instead
{ ts '2003-03-25 00:00:00.000000' }

blog comments powered by Disqus