Home > Blockchain >  Data in Oracle apex
Data in Oracle apex

Time:03-01

If I want to take data for today from 00:00 until currently hour how can I do it ??? I have this table

datetime hourly clientchannel servicename service_count
13_02_2022 9 ***** notification 2

CodePudding user response:

Presuming that datetime column's datatype is DATE (should be), then

select *
from your_table
where datetime between trunc(sysdate) and trunc(sysdate, 'hh24')

because

SQL> alter session set nls_date_format = 'dd.mm.yyyy hh24:mi:ss';

Session altered.

SQL> select sysdate as right_now,
  2    trunc(sysdate) as midnight,
  3    trunc(sysdate, 'hh24') this_hour
  4  from dual;

RIGHT_NOW           MIDNIGHT            THIS_HOUR
------------------- ------------------- -------------------
01.03.2022 08:01:20 01.03.2022 00:00:00 01.03.2022 08:00:00

SQL>

If datetime's datatype is VARCHAR2 (bad choice), then you should first convert it to date, applying correct format model and hoping that there's no garbage in that column:

where to_date(datetime, 'dd_mm_yyyy') between ...
  • Related