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 the Difference between 1) ER MODEL and Relational Model 2) Dense Index and Sparse Index

1 Answers  

What are the advantages of oracle 12c?

0 Answers  

What language does oracle use?

0 Answers  

Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table

5 Answers  

What is a Garbage Collection? and what is full recursive Garbage collection?

0 Answers   RBS,

How to view the dropped tables in your recycle bin?

1 Answers  

Can a formula column be obtained through a select statement ?

0 Answers   Oracle,

Explain the use of owner option in exp command.

0 Answers  

What is key preserved table?

0 Answers  

What is a system tablespace?

0 Answers  

What is a Sequence ?

3 Answers  

When do I need to use a semicolon vs a slash in oracle sql?

0 Answers