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

What is the use of partition by in sql?

0 Answers  

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

How do you know if a relationship is 2nf?

0 Answers  

Why indexing is needed?

0 Answers  

What is sql profiling in oracle?

0 Answers  

what is global table

7 Answers   iFlex,

there are .......different types of serializability

1 Answers   Wipro,

What is forward declaration in pl sql?

0 Answers  

What does fetching a cursor do?

0 Answers  

What are the sql aggregate functions?

0 Answers  

how to create a new table by selecting rows from another table in mysql? : Sql dba

0 Answers  

Is sql easier than java?

0 Answers