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

Explain a segment?

1131

What is data type in oracle?

1185

What are the database administrators utilities available?

1096

What is sharded cluster?

1071

How many data types are supported?

1140

Is oracle a language?

990

How to run create database statement?

1081

How to define a data source name (dsn) in odbc manager?

1084

How to call a sub procedure?

1148

Why do we need oracle client?

1009

How do I know if oracle client is installed on windows?

1096

What is translate in oracle?

1146

Can we call procedure inside function in oracle?

1151

Does facebook use oracle?

1085

what is the difference between restoring and recovering?

1059