how to truncate date and get only time part 9:20:00
Answer Posted / parna
select to_char(sysdate,'HH24:MM:SS')from dual;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
When do I need to use a semicolon vs a slash in oracle sql?
What is a user account in oracle?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Explain a synonym?
What happens to the indexes if a table is recovered?
What is bind variable in oracle 11g?
Explain the difference between a procedure and a function?
How to convert character types to numeric types?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How many types of auditing in Oracle?
Where are the settings stored for each instance in oracle?
Explain the different normalization forms?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What privilege is needed for a user to connect to oracle server?
Give the advantages and disadvantages of clusters.