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 character functions?

0 Answers  

Name the different types of indexes in sql and define them.

0 Answers  

How can check sql version from command line?

0 Answers  

Is sql microsoft?

0 Answers  

What is clause in sql?

0 Answers  

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  

What is synonyms?

0 Answers  

Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

what is the difference between a having clause and a where clause? : Sql dba

0 Answers  

What is pls integer?

0 Answers  

What does cursor do in sql?

0 Answers