how to truncate date and get only time part 9:20:00
- 5 Answers
- 8205 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 data file?
which language is used to develop the oracle........?
how to store only time in a data base table
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
How to create a single index for multiple columns?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
Explain alias?
What is merge statement used for?
How to check your oracle database 10g xe installation?
What is proxy method?
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
What is meant by joins?
Oracle General 
