how to truncate date and get only time part 9:20:00
Answer Posted / saisivakumar
select <column_name>,to_char (<column_name>,'fmdd month
yyyy fmhh:MI:ss am') from <table_name> where
condition;
Note: i have given for both date and time, pls use as u
want.
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is recovery manager in Oracle?
What is the use of oracle?
Explain about integrity constraint?
What is a read write transaction in oracle?
What is recovery manager(rman) backup in Oracle?
What language does oracle use?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is the quickest way to fetch the data from a table?
Explain index?
how to join query for one source type is oracle another source type is sql server ?
How to lock and unlock a user account in oracle?
What is an oracle data file?
What are the advantages of oracle?