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

how to store only time in a data base table

Question Posted / ns

Answer Posted / ns

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

969

What is dual table oracle?

927

What do you understand by a database object?

990

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1814

What is an oracle database?

991

What are the logical operations?

1066

How do you tell what your machine name is and what is its IP address?

2007

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2902

how do u setup a replication site?

1925

How to assign values to variables?

1046

what is IDE,DMV in sql server?

2754

How to write a left outer join with the where clause in oracle?

1027

What are the various oracle database objects?

1093

What is oracle latest version?

1039

Can we connect to ORACLE db using Windows Authentication?

1183