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

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

Question Posted / sandeep

Answer Posted / sandeep

Is This Answer Correct ?

9 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the advantages of oracle 12c?

1119

How to generate query output in html format?

1031

What is the fastest query method to fetch data from the table?

1291

What are the restrictions in a oracle read only transaction?

967

What is a subquery in oracle?

1040

What do you understand by database schema and what does it hold?

1177

Explain the use of full option in exp command.

1054

How to pass a cursor variable to a procedure?

1039

What do you understand by a database object? Can you list a few of them?

970

Explain the characteristics of oracle dba?

1067

Explain the use of record option in exp command.

946

In which language oracle has been developed?

1013

How to create a temporary table in oracle?

1191

How to login to the server without an instance?

1103

Compare and contrast between sql and sql server and explain its various functions?

917