Answer / prasant

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

if any issue,contact me.

Answer / kiran kumar

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

Answer / kavitha nedigunta

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

Answer / ajit nayak

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

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';

Answer / ajeet

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

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

Answer / chaitu

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

Answer / emmanuel

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

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

Name some usages of database trigger?

0 Answers  

What is the trigger in sql?

0 Answers  

What are some predefined exceptions in pl/sql?

0 Answers  

What does stand for in sql?

0 Answers  

what are the advantages of sql ? : Sql dba

0 Answers  

what is a tablespace? : Sql dba

0 Answers  

How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,

real time applications of nullif?

3 Answers  

What view means?

0 Answers  

What is sql constant?

0 Answers  

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

Can a procedure in a package be overloaded?

0 Answers   EXL,