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

What is mutating table error?

1163

What are the different dcl commands in sql?

1120

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

925

What does the sign mean in sql?

968

How can you view the errors encountered in a trigger?

947

How sql query is executed?

1115

what are the 'mysql' command line options? : Sql dba

1063

What is the difference between union and union all command?

1066

What is the difference between sum and count in sql?

975

What is Histogram?

1550

Is the primary key an index?

1019

What are tables and fields in the database?

1095

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

950

What is query execution plan in sql?

1174

What is the difference between a subquery and a join?

1078