how to truncate date and get only time part 9:20:00
- 5 Answers
- 8542 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 |
What is clusters ?
How can we find out the current date and time in oracle?
Explain the use of analyse option in exp command.
What is control file used for?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
How does oracle handle read consistency?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
Is insert autocommit in oracle?
How to list all user accounts in oracle?
How to drop a stored function?
What is snapshot is too old? Give and example for better understand.
Oracle General 
