Interested to Buy Any Domain ? << Click Here >> for more details...
how to truncate date and get only time part 9:20:00
- 5 Answers
- 9791 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 |
In what script is snap$ created? In what script is the scott/tiger schema created?
How to resolve the ORA-39133 error in Oracle?
What is the implicit cursor in oracle?
How to create a table in a specific tablespace?
What is the difference between alert log file and trace file ?
What is the data type of dual table?
How different is ms access and oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
Why do you use stored procedures and state some of its disadvantages?
Explain constraining triggers.
List the parts of a database trigger.
What is transport network substrate (tns) in oracle?
Oracle General 
