Interested to Buy Any Domain ? << Click Here >> for more details...
how to truncate date and get only time part 9:20:00
- 5 Answers
- 9948 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 key preserved table?
What is an Index ? How it is implemented in Oracle Database ?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Is there an oracle sql query that aggregates multiple rows into one row?
What are the different types of synonyms?
how to do daily transactions with out sql* loader control file regesterd in apps?
How to rename an index?
What is a deadlock ? Explain .
Can a formula column referred to columns in higher group ?
State any two functions of oracle?
What is oracle update statement with inner join ?
Oracle General 
