Interested to Buy Any Domain ? << Click Here >> for more details...
how to truncate date and get only time part 9:20:00
- 5 Answers
- 9725 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 |
How can windows applications connect to oracle servers?
What is an Integrity Constrains ?
How to update a table row with a record?
what is the difference between restoring and recovering?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
Which environment variables are absolutely critical in order to run the OUI?
how to hide the stored procedure inside a package
How to assign values to data fields in record variables?
Explain index?
List the parts of a database trigger.
List out the components of logical database structure of oracle database.
What is clustered table in Oracle?
Oracle General 
