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 numeric comparison operations?

1093

Explain the use of full option in exp command.

1089

How to set up autotrace for a user account?

1032

What is an oracle recycle bin?

978

How to use "while" statements in oracle?

1300

What are the differences between blob and clob in oracle?

1066

Explain enable novalidate constraint.

1064

Please explain compound trigger in oracle?

1037

How to count duplicated values in a column in oracle?

1023

How to create a testing table in oracle?

979

What is the use of file param in imp command?

1147

How to invoke the data pump import utility?

1143

Differentiate between translate and replace?

1083

Why do we need oracle client?

925

How to insert a new row into a table in oracle?

1138