SELECT last_name,TO_CHAR(hire_date, 'Day,dd-Mon-yy')Hire

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

Question Posted / nitin umale

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

Please Help Members By Posting Answers For Below Questions

How much does sqlite cost?

1021

what is 'mysqladmin' in mysql? : Sql dba

1009

Explain isolation levels. : Transact sql

1046

How to write a query to show the details of a student from students table whose

979

How does cross join work in sql?

1001

Is sql considered coding?

1024

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1151

How to get unique records from a table?

941

what is blob? : Sql dba

1118

What is the use of desc in sql?

956

What is varchar used for?

1068

What is an escape character in sql?

1008

Why is normalization important?

1005

What is sqlca in db2?

935

How do sql databases work?

979