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 the meaning of disabling a trigger?

1182

What is a string data type in sql?

1048

What are data types in pl sql?

1147

What are different types of indexes?

1014

What is t-sql? : Transact sql

993

How do I view a view in sql?

956

What are secondary keys?

976

Can you join views in sql?

961

What is the current version of sql?

1027

What is dbo in sql?

976

What is varchar used for?

1085

What is sql engine in oracle?

994

What is the default isolation level in sql server? : Transact sql

1035

What is use of package in pl sql?

1018

What is sql used for?

1129