Interested to Buy Any Domain ? << Click Here >> for more details...
how to truncate date and get only time part 9:20:00
- 5 Answers
- 9798 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 to use fetch statement in a loop?
What is a server parameter file in oracle?
How do we represent comments in oracle?
How to start a specific oracle instance?
How to shutdown your 10g xe server?
What does sharding mean?
What is an oracle tablespace?
can u call user defined functions in select statements
Explain about integrity constraint?
How can we find the size of a database?
Are truncate and delete commands same? If so why?
What is a Data File ?
Oracle General 
