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 difference between stored procedure and trigger?

1056

What is the limitation on the block size of pl/sql?

935

Why do we need view in sql?

931

What is sql query limit?

907

What language is oracle sql developer?

937

What is an escape character in sql?

979

What is the use of non clustered index?

926

how to decrement dates by 1 in mysql? : Sql dba

967

What is trigger and stored procedure in sql?

975

What is scope of pl sql developer in future?

947

What is pl sql architecture?

920

What is the difference between a procedure and a function?

1008

What is a data manipulation language?

963

What port does sql server use?

985

What operators deal with null?

1024