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

Why is sharding used?

0 Answers  

How to move files from one directory to another in pl sql?

0 Answers  

What is substitution variable in pl sql?

0 Answers  

define a variable representing the expression used to calculate on emps total annual remuneration.use the variable in a statement which finds all emps who can earn 30000 a year or more.

5 Answers  

What is difference between function and trigger?

0 Answers  

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

What are sql data types?

0 Answers  

How is debugging done?

0 Answers  

Explain what is dbms?

0 Answers  

Why are cursors used?

0 Answers  

discuss about myisam index statistics collection. : Sql dba

0 Answers  

How to call shell script from pl sql procedure?

0 Answers