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’);

Is subquery faster than join?

1 Answers  

Define implicit and explicit cursors.

1 Answers  

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  

What is consistency?

1 Answers  

What is function and procedure in pl sql?

1 Answers  

What is the usage of sql functions?

1 Answers  

How to assign sql query results to pl sql variables?

1 Answers  

how to convert character strings to dates? : Sql dba

1 Answers  

Where can I learn sql for free?

1 Answers  

What is inner join in sql?

1 Answers  

How do I remove sql plus from windows 10?

1 Answers  

What is Primary Key?

4 Answers   Ramco,