SQL> select ename,hiredate from emp 2 where 3 to

Write a query to find the employees from EMP table those who
have joined in Monday. (there is a column as hiredate which is
a date column i.e values are like 03-DEC-81)

Question Posted / jprakash025

5 Answers
10412 Views
I also Faced
E-Mail Answers

Answer Posted / jprakash025

SQL> select ename,hiredate from emp
2 where
3 to_char(hiredate,'day') like '%sunday%';

ENAME HIREDATE
---------- ---------
WARD 22-FEB-81
SCOTT 19-APR-87

i dont hv monday data, thats y i m using sunday

Is This Answer Correct ?

9 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is dbms? : Sql dba

934

Is there a way to automate sql execution from the command-line, batch job or shell script?

919

How do I run a pl sql program?

1066

What is the advantage of nosql?

996

What is cascade in sql?

916

what are the different functions in sorting an array? : Sql dba

969

When can we use the where clause and the having clause?

968

What is clause?

1067

What is sql injection vulnerability?

872

What is triggering circuit?

1017

What are synonyms in sql?

932

How do you modify a column in sql?

943

what is bcp? When does it used? : Sql dba

935

Show the cursor attributes of pl/sql.

998

What are the features of pl sql?

1015