Answer / arun kumar reddy

select * from
(select emp.*,to_char(to_date(hiredate),'day') as join_day from emp)
where join_day like'mo%';

Answer / sankarapandian

select *,upper(datename(dw,gedate())) as dayofweek from
employee where upper(Convert(varchar(15),datename dw,gedate
())))='MONDAY'

Answer / mohammad murtuza ali

select firstname,lastname from hire_date where
sdate='Monday'
(or)
select firstname,lastname from hire_date where
sdate='27022010'

Answer / priya

select firstname,lastname from hire_date where to_upper
(to_char(hire_date, 'mon')) = 'MON' ;

since hire_date is of date type converting the date to
again of date type is of no use.Need to convert it to
string type and select the month.

Answer / ravindra

Select first_name,Last_name
from employees
where To_date('Hire_date','Day')='Monday'

How to use boolean type in select statement?

0 Answers  

What are the types of dbms?

0 Answers  

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

how can we submit a form without a submit button? : Sql dba

0 Answers  

What is a constraint? Tell me about its various levels.

0 Answers  

Explain two easy sql optimizations.

0 Answers  

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

0 Answers  

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

what is the difference between union and union all? : Sql dba

0 Answers  

how to do backup entire database? : Transact sql

0 Answers  

what are tables and fields? : Sql dba

0 Answers  

select top 3 sal from each dept?

17 Answers   IBM, TCS,