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 truncate date and get only time part 9:20:00

Question Posted / parna

Answer Posted / parna

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

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1979

How to rename a tablespace in oracle?

1033

What is a proxy object?

1008

What is concurrency in oracle?

946

Explain a synonym?

970

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2077

WHAT IS ecc 6.0

2101

How do we represent comments in oracle?

1000

 How to use an oracle sequence generator in a mapping?

1018

How do I find the database name in oracle?

979

How to use subqueries with the in operator using oracle?

1030

What is raw datatype?

1078

How a tablespace is related to data files?

1060

What are the types of partitions in oracle?

974

What are the differences between lov and list item?

990