how to truncate date and get only time part 9:20:00

Answer Posted / sandeep

select to_char(sysdate,'HH24:MM:SS') from dual;

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to fetch the row which has the max value for a column?

535


How to convert dates to characters in oracle?

577


What is a read only transaction in oracle?

589


Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1561


How to create lov dynamically at runtime & attach to text field?

655






What is oracle analytical function?

524


How to pass parameters to procedures in oracle?

566


What exactly do quotation marks around the table name do?

544


How to connect ms access to oracle servers?

546


What is oracle server autotrace in oracle?

610


What are the attributes of the cursor?

552


How to initialize variables with default values?

627


How to sort the query output in oracle?

606


Is oracle a relational database?

516


What is a snapshot log?

557