SELECT FIRST_NAME,LAST_NAME FROM employees where TRIM(TO_CHAR(TO

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

Question Posted / prasant

Answer Posted / prasant

SELECT FIRST_NAME,LAST_NAME FROM employees
where TRIM(TO_CHAR(TO_DATE(HIRE_DATE),'DAY'))='MONDAY';

if any issue,contact me.

Is This Answer Correct ?

48 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is the use of function in sql?

1105

What is sql partition function?

1219

how to shutdown mysql server? : Sql dba

1110

What are dml commands?

1026

Explain architecture of sql server notification services?

1065

How do I edit a trigger in sql developer?

1005

What is view? Can we update view

1451

Can we insert data into materialized view?

955

What are types of indexes in sql?

1092

What are basic techniques of indexing?

1391

What is an escape character in sql?

1039

What is self-join and what is the requirement of self-join?

1153

explain advantages of myisam over innodb? : Sql dba

1073

How do I find duplicates in sql?

939

What is the most important ddl statements in sql are?

1004