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 load balancing and what u have used to do this?(sql loader)

3 Answers  

What is a system tablespace and when it is created?

0 Answers  

How to rename an existing table?

0 Answers  

How to use windows user to connect to the server?

0 Answers  

3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.

0 Answers   Wipro,

Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions

1 Answers  

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 Answers  

What would you use to improve performance on an insert statement that places millions of rows into that table?

1 Answers  

Can a View based on another View ?

3 Answers  

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance

2 Answers  

What is meant by raw datatype?

0 Answers  

How to turn on or off recycle bin for the session?

0 Answers