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

how to shutdown mysql server? : Sql dba

1027

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1109

What is t sql in sql server?

997

What is sql not null constraint?

978

What is difference sql and mysql?

936

Does execute immediate commit?

1145

Where the sql database files are stored?

951

How many types of indexes are there in sql?

932

What is data modelling in sql?

956

Can we perform dml in function?

1010

Can %notfound return null after a fetch?

996

What is a table?

955

How do I start pl sql?

892

what is subquery? : Sql dba

1064

What pl/sql package consists of?

1029