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

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

Question Posted / parna

5 Answers
9716 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

How can we create the complete backup of data in the oracle.

2132

How to select an oracle system id (sid)?

1046

How remove data files before opening a database?

1047

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2243

What is the difference between PFILE and SPFILE in Oracle?

1033

How to create a table in a specific tablespace?

948

What is the difference between a hot backup and a cold backup in oracle?

997

What operating systems are supported by oracle database 10g xe?

1017

What is rich query?

958

What is dual table oracle?

964

How to insert a record into a table?

1050

What are the differences between primary key and unique key?

988

How to assign query results to variables?

1033

What is coalesce function?

1051

How is it different from a normal table?

1008