473,396 Members | 1,861 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.

How to retrieve alerts/information from a db of alerts that happened between 7

I'm trying to retrieve alerts/information from a db of alerts that happened between 7 a.m to 7:30p.m, can someone pls give me a detailed db2 select statement on how I can accomplish this?
May 3 '12 #1
2 1676
Rabbit
12,516 Expert Mod 8TB
Expand|Select|Wrap|Line Numbers
  1. SELECT *
  2. FROM someTable
  3. WHERE eventTimeStamp BETWEEN 
  4. '2012-01-01 7:00:00.0' AND '2012-01-01 19:30:0000'
May 3 '12 #2
Did yur suggestion and I got an error back, please look below syntax and see if I'm doing anything wrong:

select DB2INST1.REPORTER_STATUS_NEW.CONSUMER, DB2INST1.REPORTER_STATUS_NEW.SEVERITY
from DB2INST1.REPORTER_STATUS_NEW where timestamp BETWEEN '2012-05-01 10:00:00' and '2012-05-02 12:00:00')
and DB2INST1.REPORTER_STATUS_NEW.SEVERITY > 3 GROUP BY DB2INST1.REPORTER_STATUS_NEW.CONSUMER, DB2INST1.REPORTER_STATUS_NEW.SEVERITY ORDER BY DB2INST1.REPORTER_STATUS_NEW.CONSUMER, DB2INST1.REPORTER_STATUS_NEW.SEVERITY fetch first 10 rows only
May 3 '12 #3

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

Similar topics

0
by: Crystal | last post by:
Hi there, I need to retrieve multi files information. Instead of creating my own file brower, I think I can use Windows Explore to navigate these files. Can someone tell me how I can get the file...
1
by: niftyhawk | last post by:
Hi, How do I store and retrieve session state information using C# and ASPState SQL Server Database? Thanks
3
by: vaidas gudas | last post by:
How from asp.net page retrieve all information about user how using the asp.net page. Authentication type is "Windows" and the user is in the domain
0
by: Grant Merwitz | last post by:
Hi I have an ASP.NET project. Lately, every time i try refresh the project, or show the hidden files, i get an error message which reads "Unable to retrieve folder information from the...
2
by: Stefke | last post by:
Hi, I want to write a little application with a textbox in which I can enter a systems host name or ip address. After clicking on a button Get Info, I want to display an overview of the systems...
3
by: BlueSky | last post by:
Hi, I have to retrieve user information from active directory in ASP.NET by passing Employee ID to it. Can any one give me some information on how I should do this? Thanks!
2
by: Steve Barnett | last post by:
I'm trying to put together a class that retrieves version information from my assembly and am having a problem. The code below happily retrieves the AssemblyTitle and AssemblyDescription but fails...
2
by: shantanu | last post by:
Dear All I need to do a implementation in c#. The requirement is like i have to retrieve the information of the installer , like version and compare it with the version of the new installer.How...
3
by: Stimp | last post by:
I am running Visual Studio 2003 and while opening ANY of my ASP.NET 1.1 projects I get the following error appearing in an alert box: "Unable to retrieve folder information from the server" ...
0
by: liadmz | last post by:
Hi All, I'm looking for a way to retrieve the DNS information of a given domain. the information I would like to get is: Domain's Name server Domain's MX Server Thanks for the help
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
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
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...

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.