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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

how to store only time in a data base table

Question Posted / ns

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 to lock and unlock a user account in oracle?

1049

Hi Can any one tell me what are the API's used in requisition import.

1893

What is snapshot is too old? Give and example for better understand.

1557

What is meant by a deadlock situation?

1071

What privilege is needed for a user to connect to oracle server?

961

What are the original export and import utilities?

1087

What is data file?

1065

What is a server parameter file in oracle?

1022

Is it possible to split the print reviewer into more than one region ?

2237

How to convert character types to numeric types?

1071

How to count groups returned with the group by clause in oracle?

1029

What is the oracle implicit cursor?

1021

How to create a new view in oracle?

1029

What are the attributes of cursor?

1013

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1965