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

which types of join is used in sql widely? : Sql dba

713

What are the types of dbms?

718

What is the use of non clustered index?

709

How to combine two stored procedures in sql?

802

Explain ddl statements in pl/sql?

734

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1000

What is sql character function?

710

What does inner join mean?

757

what is the functionality of the function htmlentities? : Sql dba

692

What is foreign key sql?

746

What is $$ in sql?

728

how to include character strings in sql statements? : Sql dba

733

What is the mutating table and constraining table?

738

Which is faster union or join?

702

What is a temporal table?

666