Re: Will a 2nd CPU boost Read Performance - NT/Oracle8

In article <6jc1il$hve$1_at_nnrp1.dejanews.com>,   bonanos_at_yahoo.com wrote:
>
> In article <6jbf7g$pcd$1_at_nnrp1.dejanews.com>,
> peterwiley_at_hotmail.com wrote:
> >
> >
> > BTW, when, oh when, is Oracle going to get a SQL92 timestamp data type?
> >
> > TIA, Peter Wiley
>
> Dunno if this will help but oracle do have a time series data cartridge,
> you can find out more about it at:
>
> http://www.oracle.com/st/cartridges/time/

Thanks, but it's still useless to me, I think. See below from their specs:

Frequency and Precision

 Each calendar has a frequency that is one of the following, representing the length of time included
 in each time stamp:

      second
      minute
      hour
      day
      week
      month
      quarter
      year

The finest granularity is still second. Java timestamp datatype is I believe based on SQL92 standard and goes (IIRC - manual is elsewhere) to nanosecond, certainly to millisecond. I routinely need/use millisecond. At the moment the only way to do this in Oracle is to add an extra column to hold the fractional part of the second. This is really a kludge, especially coming from Informix with its DATETIME YEAR to MILLISECOND data type.

Also, if anyone knows how to avoid using to_char & to_date when dealing with time granularity less than a day, I'd love to know. At the moment our Java code has a lot of Oracle specific code just so we can read/write data. Being able to code

SELECT <something> FROM <sometable>
WHERE Timestamp = '1998-03-02 10:00:00.000'

is a lot nicer, esp. as this is how a timestamp appears in Java (and Informix). Not to mention being able to add time intervals to dates or datetimes and end up with another datetime.

Peter Wiley

Peter Wiley

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 13 1998 - 19:02:11 CDT