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
What are the numeric comparison operations?
Explain the use of full option in exp command.
How to set up autotrace for a user account?
What is an oracle recycle bin?
How to use "while" statements in oracle?
What are the differences between blob and clob in oracle?
Explain enable novalidate constraint.
Please explain compound trigger in oracle?
How to count duplicated values in a column in oracle?
How to create a testing table in oracle?
What is the use of file param in imp command?
How to invoke the data pump import utility?
Differentiate between translate and replace?
Why do we need oracle client?
How to insert a new row into a table in oracle?