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...

Is it possible to enter only time value into a column of a
table in sql?

Answer Posted / zaheer

No,
you can store as (HH24:MI) at form level, also make format
DateTime.
Query by - to_date(HH24:MI)
Also you can use Timestamp - I tied it in Oracle 10g. It
will store date and time

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a cursor and what are the steps need to be taken?

1116


How to write a query with an inner join in oracle?

973


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2200


How do I spool in oracle?

939


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

1056


What is ceil and floor in oracle?

1007


Does facebook use oracle?

979


What is the use of file param in imp command?

1115


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

2092


What is an oracle?

956


What is the difference between count (*), count (expression), count (distinct expression)?

964


Can we connect to ORACLE db using Windows Authentication?

1181


Explain what are the different type of segments?

911


What is oracle and what are its different editions?

1007


Is postgres faster than oracle?

969