Get the App
SLTechnology News&Howtos  ›  Database  › 

How does oracle realize the function of dynamically querying data from 8: 00 a.m. to 8: 00 a.m. The day before?

Shulou Source: shulou.com Published: 2022-05-31 22:02:26 11月17日 Update

This article is about how oracle can dynamically query data from 8: 00 a.m. to 8: 00 a.m. the day before. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

You need to query the data from 8: 00 a.m. to 8: 00 a.m. the day before.

Here is the query sql statement

SELECT DEPT_ID, COUNT (*) DIDFROM "MES_MACH_CALL_EVENT" WHERE CALL_TIME > = trunc (sysdate-1) + 8max 24 AND CALL_TIME

Tags: Date query data point to time format function dynamic content function hour week more article good practical year article method read Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Shulou Technology Microsoft MariaDB Shulou Tech Info Xiaomi