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

How can I create database in oracle?

574


Explain what are the type of synonyms?

583


How do you store pictures in a database?

563


What is a cognitive schema?

529


Can we insert data in view oracle?

543






What is an index associated with a constraint?

554


what is dynamic SGA and static SGA

3845


What exactly do quotation marks around the table name do?

548


How to define a variable of a specific record type?

615


What is proxy method?

545


What is a proxy class?

562


What is a system tablespace?

602


How to export your own schema?

577


Where is the export dump file located?

575


What is the difference between alert log file and tarce file ?

1637