Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 is the data pump import utility?

1040


Explain oracle insert into command?

1116


What is bulk copy or bcp in oracle?

1125


What is oracle rowcount?

1090


How to invoke the data pump import utility?

1171


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.

2270


Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1153


What are the uses of Database Trigger ?

1725


How can windows applications connect to oracle servers?

1060


How to resolve the ORA-39133 error in Oracle?

1126


How to create a stored program unit?

1234


Can we connect to ORACLE db using Windows Authentication?

1264


what are the default admin accounts in Oracle 10g ?

972


what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2266


Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

1789