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

What are primary key and foreign key and how they work?

960

Which join is like inner join?

1005

What is int identity in sql?

1112

what is a primary key? : Sql dba

1025

What is pl sql script?

1010

How many types of tables are there?

929

What are the two types of exceptions in pl/sql?

1023

What is view explain with example?

919

What is pl sql quora?

1125

Which table is left in join?

957

what is index? : Sql dba

988

what is the difference between group by and order by in sql? : Sql dba

1104

Can procedure in package be overloaded?

1063

Explain what is a subquery ?

1164

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7262