|
| cool Statistics |
| | coolcommands: | 1338 | | Categories: | 83 | | Total queries: | 620073 | | Members: | 22813 |
|
|
|
|
 |
|
|
|
Search coolcommands.com
 |
Submitted by:
lvo |
coolcommand
how to select rows in an Oracle database by timestamp |
Description
To find rows in an Oracle database from the last 5 days:
select * from TABLENAME where TIMESTAMP > (sysdate-5);
To find rows from the last hour:
select * from TABLENAME where TIMESTAMP > (sysdate-(1/24));
To find rows from the last minute:
select * from TABLENAME where TIMESTAMP > (sysdate-(1/(24 * 60)));
To find rows from the last second:
select * from TABLENAME where TIMESTAMP > (sysdate-(1/(24 * 60 *60)));
To find rows from the last 12 minutes:
select * from TABLENAME where TIMESTAMP > (sysdate-(12/(24*60))); |
Example
select * from TABLENAME where TIMESTAMP > (sysdate-5); |
Return to search results
 | | | |
Random coolcommands
coolcommand: gr_osview - a graphical system monitor for SGI IRIX
Example: gr_osview -a
[show me the details] |
coolcommand: lssyscfg command will list the system configuration
Example: lssyscfg -r [ sys | frame | alpar | lpar | prof | sysprof ] -n object-name [ | —all ] [ -m "managed-system" ] [ -p "partition-name" ] [ -F format | -z ] [ —help ]
[show me the details] |
coolcommand: datapath query adapter (device) - Hitachi SAN - HDLM
Example: datapath query adapter 0
[show me the details] |
coolcommand: swinstall - how to install depot files in HP/UX
Example: swinstall -s /tmp/perl.depot
[show me the details] |
|
|
coolcommands.com - the search engine for UNIX sysadmins :: unix commands and scripts
| | | | |
|
|
|
|
 |
|
|
|
|
Top 5 Submitters
|
|---|
| lvo | 1160 |
| audet | 37 |
| kah00na | 32 |
| Mariom | 24 |
| lebjf000 | 14 |
Top 5 Searches
|
|---|
| Category Solaris | 51939 |
| Category AIX | 49005 |
| Category General UNIX | 47490 |
| solaris | 23554 |
| aix | 22739 |
|
|
|
|
Sunday May 19, 2013
