Answer / praveen

select to_date('Column_Name','dd-mon-yyyy') from table_name;

Answer / pulakesh

select * from testdate
where to_date(column1,'dd-mon-yyyy')=to_date(column1,'dd-
mon-yyyy') and length(column1)>8

Answer / dipti

select * from TABLE1
where VSIZE(column_name) > (select VSIZE('DD-MON-YYYY') from dual)

Answer / kumar

select * from employees
where
length(hire_date)=length(sysdate)

Answer / john bershan

select to_char(column_name,'dd-mon-yyyy') from <table_name>;

Answer / sowmya

Select date from table where date:=to_date(‘date’,’DD-MM-
YYYY’);

What is left join example?

0 Answers  

Which is better join or subquery?

0 Answers  

What is data control language (dcl)?

0 Answers  

what are the differences between require and include, include_once and require_once? : Sql dba

0 Answers  

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,

Does truncate remove indexes?

0 Answers  

Is there a 64 bit version of ssms?

0 Answers  

Does db2 use sql?

0 Answers  

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

is it possible to pass an object or table to a procedure as an argument?

0 Answers  

Explain the the update statement in sql?

0 Answers  

Is a foreign key always unique?

0 Answers