select last_name,to_char(hire_date,'day,mm,yyyy') from employees

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

Question Posted / ajeet

Answer Posted / ajeet

select last_name,to_char(hire_date,'day,mm,yyyy')
from employees
where trim(to_char(Hire_date,'day')) ='monday'

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can you inner join the same table?

933

Enlist some predefined exceptions?

993

explain the difference between myisam static and myisam dynamic. : Sql dba

884

How many commands are there in sql?

970

What is sql query optimization?

1020

Is null operator in sql?

978

what are myisam tables? : Sql dba

950

What is bulk collect in pl sql?

1018

how mysql optimizes distinct? : Sql dba

999

How do rank () and dense_rank () differ?

974

Is a foreign key always unique?

882

What is the use of stored procedures?

974

What is indexing in sql and its types?

1003

What is sql stand for?

944

What is rownum?

923