Tuesday, 15 July 2014

DATETIME : SQL SERVER QUERIES INTERVIEW FOR EXPERIENCED 2-3 YEARS WITH EXAMPLE : SET-3

SQL DATETIME QUERIES INTERVIEW QUESTIONS WITH ANSWERS
TOP 10 DATETIME RELATED INTERVIEW QUERIES
If you think this set contain easy question then you can start with Set 9 (tricky quries)and be continue.
This is the 3rd set(21-30) of SQL INTERVIEW QUERIES SET, This set is for experienced developers, it's containing datetime related interview question with answers, So test your sql skill by answers following queries by yourself first.
So lets take it as a SQL Queries Quiz

Related Table:-

***SQL DATETIME RELATED QUERIES***
21). Get only Year part of "JoiningDate".
Ans: SELECT DATEPART(YEAR, JoiningDate) FROM [EmployeeDetail]


22). Get only Month part of "JoiningDate".
Ans: SELECT DATEPART(MONTH,JoiningDate) FROM [EmployeeDetail]

23). Get system date.
Ans: SELECT GETDATE()

24). Get UTC date.
Ans: SELECT GETUTCDATE()

25). Get the first name, current date, joiningdate and diff between current date and joining date in months.
Ans: SELECT FirstName, GETDATE() [Current Date], JoiningDate,
DATEDIFF(MM,JoiningDate,GETDATE()) AS [Total Months] FROM [EmployeeDetail]

26). Get the first name, current date, joiningdate and diff between current date and joining date in days.
Ans: SELECT FirstName, GETDATE() [Current Date], JoiningDate,
DATEDIFF(DD,JoiningDate,GETDATE()) AS [Total Months] FROM [EmployeeDetail]

27). Get all employee details from EmployeeDetail table whose joining year is 2013.
Ans: SELECT * FROM [EmployeeDetail] WHERE DATEPART(YYYY,JoiningDate) = '2013'


28). Get all employee details from EmployeeDetail table whose joining month is Jan(1).
Ans: SELECT * FROM [EmployeeDetail] WHERE DATEPART(MM,JoiningDate) = '1'


29). Get all employee details from EmployeeDetail table whose joining date between "2013-01-01" and "2013-12-01".
Ans: SELECT * FROM [EmployeeDetail] WHERE JoiningDate BETWEEN '2013-01-01' AND '2013-12-01'


30). Get how many employee exist in "EmployeeDetail" table.
Ans: SELECT COUNT(*) FROM [EmployeeDetail]

Click on the following link for NEXT SET OF QUESTIONS:
CLICK HERE FOR NEST SET (MORE THAN 600 QUERIES)
Visit Our New Site for HR Interview Questions Answers http://www.interviewboat.com/Company/GetCompany
Sponsored Ads

7 comments:

  1. question no. 21 and 22 is not showing the output. It is showing out of range value.

    ReplyDelete
  2. Can u share screen shot of ur result at ahlawat.vikas24@gmail

    ReplyDelete
  3. very nice...useful for beginners

    ReplyDelete
  4. #26: Column Name in results should be "Total Days" (not Months)

    ReplyDelete
  5. how to get three months before joining employee record

    ReplyDelete