select last_name,to_char(hire_date,'day,mm,yyyy') from employees

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

Question Posted / ajeet

Answer Posted / ajeet

select last_name,to_char(hire_date,'day,mm,yyyy')
from employees
where trim(to_char(Hire_date,'day')) ='monday'

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How many tables can a sql database have?

981

What is a subquery in sql?

1046

Why is pl sql needed?

956

Can we use the cursor's to create the collection in PL/SQL?

1030

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1072

What is the use of sql trace?

956

What does trigger mean in slang?

1070

What is numeric function sql?

1068

how to fetch common records from two tables? : Sql dba

1183

What are the disadvantages of not performing database normalization?

1169

tell us something about heap tables. : Sql dba

1104

What is dml and ddl?

967

Explain what is dbms?

1071

explain access control lists. : Sql dba

1005

What is cross join sql?

924