SELECT * FROM EMP WHERE TO_CHAR(HIREDATE,'FMDAY') = 'MONDA

Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)

Question Posted / ajit nayak

Answer Posted / ajit nayak

SELECT *
FROM EMP
WHERE TO_CHAR(HIREDATE,'FMDAY') = 'MONDAY';

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to convert comma separated string to array in pl/sql?

1190

What is the benefit of foreign key?

1023

What are different types of indexes?

1014

What is use of trigger?

936

Why is pl sql used?

990

When is the update_statistics command used?

1127

What is varchar example?

1038

How do I debug a stored procedure?

1119

How do I count duplicates in sql?

1116

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

959

what is uncommittable transactions? : Transact sql

1000

How do I view tables in mysql?

987

What are % type and % rowtype?

1037

What is the difference between null value, zero, and blank space?

1209

what are the join types in tsql? : Transact sql

1068