how to truncate date and get only time part 9:20:00
- 5 Answers
- 10049 Views
- I also Faced
- E-Mail Answers
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 select all columns of all rows from a table in oracle?
How to use values from other tables in update statements using oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to put more than 1000 values into an oracle in clause?
What is oracle latest version?
How to start an oracle instance?
How to write a left outer join with the where clause in oracle?
Design database draw er diagram for a certain scenario ?
