Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find the name of employees those who have
joined on Monday.(based on column hire_date)
- 15 Answers
- 41500 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / priya
select firstname,lastname from hire_date where to_upper
(to_char(hire_date, 'mon')) = 'MON' ;
since hire_date is of date type converting the date to
again of date type is of no use.Need to convert it to
string type and select the month.
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
How do I make my sql query run faster?
What is not null in sql?
What has stored procedures in sql?
Why do we need a foreign key?
how to enter binary numbers in sql statements? : Sql dba
Is there a 64 bit version of ssms?
What is program debugging?
Explain what is rdbms?
What does bitemporal mean?
Is sql considered coding?
how do you know if your mysql server is alive? : Sql dba
how can we submit a form without a submit button? : Sql dba
What is union and union all keyword in sql and what are their differences?
how many groups of data types? : Sql dba
What is a left join?
