This content has been marked as final. Show 1 reply
Welcome to Oracle Forums! Please acquaint yourself with the FAQ if you haven't already done so.
I'm trying to create a simple query resource template that includes to_timestamp. Here is the query
select * from apex1.item
where last_update_time > to_timestamp('20120730000100', 'YYYYMMDDHH24MISS')
order by id
I'm getting 500 - Internal Server Error
Error during evaluation of resource template
If I could get this to work, I then want to pass the timestamp in as a parameter
Why exactly are you wanting to use Timestamp and that too without Timezone? Why not use the Date datatype which is simpler to handle?
What is the datatype of last_update_time ? Without TZ? With Local TZ? With TZ?