473,396 Members | 1,826 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Oracle SQL Query> Collect certian time intervatal data

Oracel SQL Query
Collect a certain time intervatal data

I'm looking for queries to collect a certain time interval data from my table.
Here is current the data in my table and as you can see, the data is set with every 5 minute.

Time Load
06/14/2011 17:45:00 2,560
06/14/2011 17:50:00 2,422
06/14/2011 17:55:00 2,348
06/14/2011 18:00:00 2,765
06/14/2011 18:05:00 2,765


However, I need to mine quater hour data in 15 minutes time interval from avobe table as below.
Time Load
06/14/2011 17:45:00 2,560
06/14/2011 18:00:00 2,765
06/14/2011 18:15:00 2,342
06/14/2011 18:30:00 2,563


Would you let me know how I can collect the time interval data from my table?
Jun 19 '11 #1
2 3078
debasisdas
8,127 Expert 4TB
How you retrieved the 1st dataset with five minutes interval ?
Jun 20 '11 #2
Rabbit
12,516 Expert Mod 8TB
If you take the minute part of the time, and if the mod 15 of that is 0 then it's a quarter hour.
Jun 20 '11 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Stormkid | last post by:
Hi Group, I'm trying to figure out a function that will check to make sure the user has not double entered a certain time frame for example I don't want them to be able to enter Mon 8:00 AM to 5:00...
4
by: sdhyok | last post by:
Hi, I am trying to build up a system handling time series data a lot. Do you know any well-designed python class specially for time series data? Thanks in advance. Shin, Daehyok
0
by: Stephen | last post by:
Hi, Suppose I have 2 tables. TableA has about 3 million rows and TableB has about 50,000 rows. Assuming a btree index is used in the time column. I need to query a limited and time ordered...
7
by: Novice Computer User | last post by:
Hi. I want people to enter specific information on my website - most likely in a form. (i.e. their name, address, etc). I then want that information to be emailed to me. Is there a way to do...
12
by: wenmang | last post by:
Hi, I am using following Oracle Proc-C compiler: Pro*C/C++: Release 8.1.7.0.0 - Production on Thu Jun 15 15:57:32 2006 (c) Copyright 2000 Oracle Corporation. All rights reserved. I like to...
2
by: shubhangi | last post by:
Hi, I want to enter only time from frontend & not date time. Can I do this & can I store this in DB. If yes, what will be data type to store only time values. How do I retrieve the time data in...
6
by: BBands | last post by:
Good morning, I store time series data in a SQL database. The results of a typical query using pyodbc look like this. Date Close "2007-01-17" 22.57 Where Date is a datetime.date...
4
by: Peter Kanurer | last post by:
Assume I add in VisualCSharp 2005 References to Oracle.DataAccess AND System.Data.OracleClient to an application. Does this cause problems or can they co-exist in one application ?
0
by: jobs | last post by:
re: Oracle Exceeded maximum idle time I have asp.net web gridview that is populated by a function that calls an Oracle procedure that returns a dataset. At most, it might take 2 or 4 seconds to...
2
by: Dale | last post by:
Access 2003 I have an access database used for scoring a high school sporting event. Data is entered as scores are turned in from the different events throughout the day. I would like to...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.