Select first_name,Last_name from employees where To_date('Hire

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

Question Posted / ravindra

Answer Posted / ravindra

Select first_name,Last_name
from employees
where To_date('Hire_date','Day')='Monday'

Is This Answer Correct ?

6 Yes

21 No

Please Help Members By Posting Answers For Below Questions

What are the disadvantages of not performing database normalization?

1214

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1147

how to analyze tables with 'mysqlcheck'? : Sql dba

1053

What does the sign mean in sql?

1047

How would you convert date into julian date format?

1041

Explain cursor types?

1080

what are the types of subquery? : Sql dba

1155

Are views faster than queries?

1038

Can variables be used in sql statements?

1073

What are different types of triggers?

1177

explain the options of myisamchk to improve the performance of a table. : Sql dba

1072

Why left join is used in sql?

1018

Can a table contain multiple primary key’s?

1154

What is column?

1031

Is sql the best database?

1020