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

What are pl/sql packages?

1107

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2172

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1033

How do I make my sql query run faster?

948

What is the difference between python and sql?

1010

can sql servers linked to other servers like oracle? : Sql dba

1013

Is record in oracle pl sql?

971

Does mysql_real_escape_string prevent sql injection?

955

What are the types of triggers in sql?

1092

What is the difference between union and union all command?

1096

What is use of term?

1068

How do you write an index?

975

Can we enter data in a table in design view?

972

What is the primary key?

956

What is dense_rank?

938