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 sql keyword?

0 Answers  

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

What is normalization sql?

0 Answers  

What has stored procedures in sql?

0 Answers  

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

what is sql optimization

1 Answers   Fidelity,

What is rtm stands for?

0 Answers  

Which are the different case manipulation functions in sql?

0 Answers  

Which sql statement is used to delete data from a database?

0 Answers  

how many triggers are allowed in mysql table? : Sql dba

0 Answers  

What is the difference between partition and index?

0 Answers  

If a cursor is open, how can we find in a pl/sql block?

0 Answers