how to store only time in a data base table

Answer Posted / ns

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between primary key and unique key?

507


Which is better Oracle or MS SQL? Why?

3965


What are the most common interview questions on ETL Testing for experience?

589


What are the different windows events activated at runtime ?

2408


What is a cognitive schema?

525






What happens to the current transaction if the session is ended?

525


What are the attributes of cursor?

585


What is oracle in java?

522


How to define a specific record type?

614


How can you use check constraints for self referential integrity?

520


What is oracle sid?

505


How to invoke the data pump export utility?

555


Can select statements be used on views in oracle?

586


21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

1618


What is ASM (Automatic Storage Management) in Oracle?

710