SELECT last_name,TO_CHAR(hire_date, 'Day,dd-Mon-yy')Hire

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

Question Posted / nitin umale

Answer Posted / nitin umale

SELECT last_name,TO_CHAR(hire_date, 'Day,dd-Mon-yy')Hire_date
FROM employees
WHERE UPPER(TRIM(TO_CHAR(hire_date, 'day')))='MONDAY';

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain the purpose of %type and %rowtype data types with the example?

929

Are subqueries better than joins?

922

how to create a new view in mysql? : Sql dba

895

Explain clause in sql?

962

What is bind variable in pl sql?

980

Does pl sql work in mysql?

923

Why use truncate instead of delete?

962

What are the advantages of pl sql?

1074

How delete all data from all tables in sql?

887

What is pl sql quora?

1072

What is the purpose of a sql?

915

What is date functions?

964

Can we create table in function?

907

How is a process of pl/sql compiled?

1087

Can you select everything, but 1 or 2 fields, without writer's cramp?

934