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

What is orm in sql?

547

What is benefit of creating memory optimized table?

545

What does cursor do in sql?

527

Cite the differences between execution of triggers and stored procedures?

632

Are stored procedures compiled?

533

what is 'mysqld'? : Sql dba

554

What are the benefits of pl sql?

540

Why do we use %rowtype & %type in plsql?

618

What is the difference between the implicit and explicit cursors?

535

How is data stored on a disk?

553

What are string functions in sql?

688

What are the types of optimization?

529

What is a sql trace file?

557

What are different types of keys?

532

How to return an array from java to pl/sql?

604