SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Extract then time portion from the date-time column

945595Oct 25 2012 — edited Oct 25 2012

Hello guys,
I want to extract then time portion from the date-time column. I have tried the below mentioned code but I am unable to retrieve it, The code as follows,

select CONVERT (VARCHAR2(24),sysdate,108) from dual

It is showing "ORA-00936: missing expression" .

Please help me with the same.

I thank you in advance.

Regards,
Uraja

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 22 2012

Added on Oct 25 2012

#column, #time

8 comments

1,640 views