Re: TIMESTAMP datatype. Anyone using them?

On 8/1/05, Arnold, Sandra <ArnoldS_at_osti.gov> wrote:
> Is anyone using the TIMESTAMP datatype? We are thinking about using them
> but are having a problem with queries using the BETWEEN clause. If you are
> using them, how are you querying them for date ranges?

Sandra,

We're using timestamps, but most of our queries just do a < or >, not between.

However, I had a problem a little while ago with java and timestamps. A query using an index on a date column started doing full tablescans after a new app deployment. Apparently someone changed the classpath on the app server. It took a session trace showing the bind variable coming in as a timestamp to convince the dev team the database hadn't suddenly lost its mind.

Anyway, watch out for implicit conversions if you have both dates and timestamps.

Steven

--
http://www.freelists.org/webpage/oracle-l