select convert(varchar(10), dateadd(dd,-(day(dateadd(mm,1,getdate()))-1),

I want to display the employees who have joined in last two
months. (It should be executed randomly means If I execute
the query in March it should display Jan and Feb joined
employees. Same query if i execute in Feb, 2007 it should
display dec, 2006 and jan 2007 joined employees.

Question Posted / balaji s.t

15 Answers
50758 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / balaji s.t

select convert(varchar(10),
dateadd(dd,-(day(dateadd(mm,1,getdate()))-1), dateadd(mm,-2,getdate())), 120),

convert(varchar(10),dateadd(dd,-(day(getdate())),getdate()),120)

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql dialect?

1180

What are the possible values for the boolean data field?

1016

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1080

How do you modify a column in sql?

1054

How many functions are there in sql?

1096

What is the difference between python and sql?

1056

what are dynamic queries in t-sql? : Transact sql

1070

Is stored procedure faster than query?

1021

What is pl sql in oracle?

1099

What are the basic sql commands?

1142

What are the topics in pl sql?

1024

What are records give examples?

1054

How to create your own reports in sql developer?

1066

What is scalar data type in pl sql?

1119

What is rowtype?

1081