how to truncate date and get only time part 9:20:00
- 5 Answers
- 8544 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
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
what are the advantages of running a database in archive log mode?
What is the disadvantage of User defind function?
In the oracle version 9.3.0.5.0, what does each number shows?
How would you change old and new values in an insert, delete and update triggers?
How many anonymous blocks can be defined?
What are the numeric comparison operations?
What is the usage of save points in oracle database?
What is a static data dictionary in oracle?
How many types of synonyms in Oracle?
what is reindexing?
How to run the anonymous block again?
How to convert dates to characters in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How can we find out the current date and time in oracle?
