how to truncate date and get only time part 9:20:00

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / vijay

5 Answers
9959 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to truncate date and get only time part 9:20:00..

Answer / sandeep

select to_char(sysdate,'HH24:MM:SS') from dual;

Is This Answer Correct ?

9 Yes

1 No

how to truncate date and get only time part 9:20:00..

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

how to truncate date and get only time part 9:20:00..

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

how to truncate date and get only time part 9:20:00..

Answer / parna

select to_char(sysdate,'HH24:MM:SS')from dual;

Is This Answer Correct ?

1 Yes

2 No

how to truncate date and get only time part 9:20:00..

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

Post New Answer