Extract number from the date in pl sql

Question

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

example.

SELECT SYSDATE FROM DUAL

and here the output would be say : 26-10-2010 13:30:34

Now I want to have just the date as a number. In this case that would be 26.

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

Answer 1

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

Answer 2

You can also use EXTRACT(), like so:

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

Answer 3

You can use

to_char(SYSDATE, 'DD')

More you can read here: LINK

Answer 4

All format models are described in the official SQL Reference, take a look in case you need something else