From: Matt <zagnimp@aom.bt.co.uk>
Subject: easy Q howto select between hrs & mins ?
Date: 2000/06/06
Message-ID: <393D2CD0.AE00C2BE@aom.bt.co.uk>#1/1
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: postmaster@axion.bt.co.uk
X-Trace: pheidippides.axion.bt.co.uk 960310593 12253 132.146.248.159 (6 Jun 2000 16:56:33 GMT)
Organization: BT Adastral Park, Martlesham Heath, Ipswich, UK
Mime-Version: 1.0
NNTP-Posting-Date: 6 Jun 2000 16:56:33 GMT
Newsgroups: comp.databases.oracle.misc


Hi

Simple Question.

What is the quickest way to select using to_char from data_time
mins/second where date_time is more than  x date_time mins/seconds)

ie I have a large table that contains many records per day, displaying
the times is easy but selecting only unique times between time1 and
time2 (DDMONYY  HH24:MM:SS) is harder any ideas on a
query that will not impact the performance to hard on a large
realtime system ?

Regards

Matt