1 Reply Latest reply: Jul 31, 2012 5:30 AM by Prabodh RSS

    to_timestamp in resource template returning an error

    749019
      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

      to_timestamp(:ptime, 'YYYYMMDDHH24MISS')

      Any ideas?
        • 1. Re: to_timestamp in resource template returning an error
          Prabodh
          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

          to_timestamp(:ptime, 'YYYYMMDDHH24MISS')

          >
          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?

          Cheers?