Select * from emp Where to_char(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 / emmanuel

Answer Posted / emmanuel

Select * from emp
Where to_char(TO_DATE(hire_date),'day')='monday';

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does db2 use sql?

1006

What is trigger in sql?

1154

Does mysql_real_escape_string prevent sql injection?

991

How do I edit a stored procedure?

1046

What is int identity in sql?

1201

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

1012

Can I create table without primary key?

1041

Is left join same as inner join?

1213

What is coalesce sql?

1050

How many types of relationship are there?

1080

How is a PL/SQL code compiled?

1280

Explain sql data types?

1143

What is before trigger?

1048

What are the query optimization techniques?

994

Why is %isopen always false for an implicit cursor?

1150