Extract number from day in pl sql

Question

Does anyone know if it is possible to take a date from a random date in pl sql.

Example.

SELECT SYSDATE FROM DUAL

and here the result will be displayed: 26-10-2010 13:30:34

Now I want to have only a date as a number. In this case, it will be 26.

Or there is some kind of function like IsNum that can recognize it for me. So I can just take 26 and leave the rest.

Answer 1

select to_char(sysdate,'DD') as day from dual

Answer 2

You can also use EXTRACT(), for example:

SELECT EXTRACT(DAY FROM SYSDATE) AS DAY FROM DUAL;

Answer 3

to_char(SYSDATE, 'DD')

:

Answer 4

SQL Reference, , -

Answer 5

select count(*) from 
     (select sysdate+rownum dates from  dual connect by rownum < (sysdate+15)-(sysdate))  
   where to_char(dates,'D') <> '1' and to_char(dates,'D') <> '7'