how to truncate date and get only time part 9:20:00
- 5 Answers
- 8174 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sandeep
select to_char(sysdate,'HH24:MM:SS') from dual;
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / pari
declare
str varchar2(250);
str1 varchar2(250);
begin
select to_char(sysdate,'dd-mm-yyyy hh:mi:ss') into str from
dual;
dbms_output.put_line (str);
str1 := substr(str,instr(str,' ',1)+1 );
dbms_output.put_line (str1);
end;
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / kumar.t
Select Convert(varchar,getdate(),114) As DateTime
It is Only Run In Sql Server2000
By
Kumar .T
| Is This Answer Correct ? | 0 Yes | 1 No |
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
How to view the data files in the current database?
How to delete multiple rows from a table in oracle?
What is Trigger in Oracle?
What is flashback Query ? And Use ?
Can we create more than one constraint to column ?
How to drop an existing table in oracle?
What happens to the indexes if a table is recovered?
What is meant by recursive hints ?
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
How many types of segments in Oracle?
Explain the use of indexes option in exp command.
Oracle General 
