How to write a query filter that extracts a single day data for TNPMW

Technote (FAQ)


Question

How to write a query filter that extracts a single day data for TNPMW

Answer

There are obviously many ways to write such query filter, but given the current implementation, there is only one efficient way to do that.

Assuming we have a traffic table T1, with the standard column that contains timestamp 'TSTAMP', and we want data for the entire 1-Jan-2012, this is how it should be written:

SQL Code SELECT .... FROM T1
WHERE TSTAMP >= TO_DATE('01-01-2012 00:00:00', 'DD-MM-YYYY HH24:MI:SS')
AND TSTAMP < TO_DATE('02-01-2012 00:00:00', 'DD-MM-YYYY HH24:MI:SS');


Product Alias/Synonym

TNPMW

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Netcool Performance Manager for Wireless

Software version:

1.2.1, 1.3

Operating system(s):

AIX, Solaris

Software edition:

All Editions

Reference #:

1595066

Modified date:

2013-04-15

Translate my page

Machine Translation

Content navigation