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

suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

Why having clause is used in sql?

0 Answers  

Which join is default?

0 Answers  

What is sql keyword?

0 Answers  

What is the maximum size of sqlite database?

0 Answers  

what is d diff between grant,commit,rollback n savepoint

1 Answers  

What is rtm in testing?

0 Answers  

Does truncate release storage space?

0 Answers  

What is the basic structure of PL/SQL ?

6 Answers  

how to create a table index in mysql? : Sql dba

0 Answers  

How can get second highest salary in sql?

0 Answers  

what are pl/sql collections?

4 Answers   JPMorgan Chase, Oracle,