Jump to Real's How-to Main page

"Access or violation" error using timestamp with Oracle

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' }

If you find this article useful, consider making a small donation
to show your supportfor this Web site and its content.

Written and compiled by Réal Gagnon ©1998-2005
[ home ]