Write a query to find the name of employees those who have joined on Monday.(b

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

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

Question Posted / lmeher.tcs

15 Answers
40629 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / prasant

SELECT FIRST_NAME,LAST_NAME FROM employees
where TRIM(TO_CHAR(TO_DATE(HIRE_DATE),'DAY'))='MONDAY';

if any issue,contact me.

Is This Answer Correct ?

48 Yes

8 No

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

Answer / kiran kumar

SELECT * FROM EMP
where TRIM(TO_CHAR(TRUNC(HIREDATE),'DAY'))='SUNDAY'

Is This Answer Correct ?

23 Yes

7 No

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

Answer / kavitha nedigunta

select ename
from emp
where trim(to_char(Hiredate,'day')) ='monday'

Is This Answer Correct ?

19 Yes

5 No

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

Answer / ajit nayak

SELECT *
FROM EMP
WHERE TO_CHAR(HIREDATE,'FMDAY') = 'MONDAY';

Is This Answer Correct ?

6 Yes

1 No

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

Answer / nitin umale

SELECT last_name,TO_CHAR(hire_date, 'Day,dd-Mon-yy')Hire_date
FROM employees
WHERE UPPER(TRIM(TO_CHAR(hire_date, 'day')))='MONDAY';

Is This Answer Correct ?

3 Yes

1 No

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

Answer / 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

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

Answer / mahendar reddy

SELECT ENAME FROM EMP WHERE TO_CHAR(TO_DATE(HIREDATE),'D')='2';

IT fetch the employee name who joined on monday
Here
1=sunday
2=monday
--
---
--
--
--etc

Is This Answer Correct ?

2 Yes

0 No

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

Answer / chaitu

select ename,to_char(hiredate,'Day') from emp
where trim( to_char(hiredate,'Day'))='Monday'

Is This Answer Correct ?

1 Yes

1 No

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

Answer / emmanuel

Select * from emp
Where to_char(TO_DATE(hire_date),'day')='monday';

Is This Answer Correct ?

0 Yes

0 No

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

Answer / venkat

Select first_name,Last_name
from employees
where To_date('HIREDATE','D')=2;

1-SUNDAY
2-MONDAY
----
7-SATURDAY

The advantage of the above query even don't know about the
format of day of the week We get the output.
Monday,
MON
MONDAY
ETC

Is This Answer Correct ?

6 Yes

7 No

Post New Answer