Answer / sandeep

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

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;

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.

Answer / parna

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

Answer / kumar.t

Select Convert(varchar,getdate(),114) As DateTime

It is Only Run In Sql Server2000

By

Kumar .T

What is a Synonym ?

3 Answers  

What is ADDM Advisor in Oracle?

0 Answers   MCN Solutions,

What is the difference between truncate & delete command?

0 Answers  

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 Answers  

4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>

1 Answers   Wipro,

Is primary key indexed by default in oracle?

0 Answers  

How many categories of data types in oracle?

0 Answers  

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

what is the difference between data migration and production migration.

0 Answers  

what is the difference between authorization and authentication?

4 Answers   MAHINDRA, PUCIT,

Please explain joins in oracle?

0 Answers  

Whatz the main diff between Subquery and a Join

14 Answers   Oracle, Zeta Interactive,