Extract time part from TimeStamp column in ORACLE

You could always do something like:

select TO_DATE(TO_CHAR(SYSDATE,'hh24:mi:ss'),'hh24:mi:ss') from dual

I believe this will work with timestamps as well.

You want just date then use

to_char(cast(SYSDATE as date),'DD-MM-YYYY')

and if you want just time then use

to_char(cast(SYSDATE as date),'hh24:mi:ss')

the parameters are making all the changed

'DD-MM-YYYY'

and

'hh24:mi:ss'

What about EXTRACT() function?

Related