|
[oracle-l]
||
[Date Prev]
[08-2005 Date Index]
[Date Next]
||
[Thread Prev]
[08-2005 Thread Index]
[Thread Next]
Re: TIMESTAMP datatype. Anyone using them?
- From: jungwolf <spatenau@xxxxxxxxx>
- To: ArnoldS@xxxxxxxx
- Date: Mon, 1 Aug 2005 14:53:01 -0500
On 8/1/05, Arnold, Sandra <ArnoldS@xxxxxxxx> 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
|
|
