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

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

2 Answers   Allfon,

---

Explain what are the characteristics of data files?

1 Answers  

---

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

2 Answers   MasterCard,

---

What is the CAP theorem?

1 Answers  

---

How to rename a column in an existing table?

1 Answers  

---

What do you understand by a database object? Can you list a few of them?

1 Answers  

---

What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?

1 Answers   TCS,

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1 Answers  

---

How to handle a single quote in oracle sql?

1 Answers  

---

What is a nested table?

1 Answers  

---

Explain the use of rows option in imp command.

1 Answers  

---

How to define a variable to match a table column data type?

1 Answers  

---