Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

CSharp TV
Videos
Tech
Articles
Blogs
News
Forums
Books
Events

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Latest Forum Questions

how do you delete an account
Guest User2h ago3
How do cybersecurity teams analyze MBOX files?
Shubham Singh12h ago3
Performance Improvements and Optimization Features in the Latest Python Release
G.Devi12h ago0
What Are the Common Challenges in Web Application Testing, and How Can QA Teams Overcome Them?
Sunil Patel14h ago2
Get-ExchangeServer | Format-Table Name, Edition,
Muhd Alyph14h ago1

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

How to Get Employees Period in Company as per Employee Joini

Home
Forums
SQL

How to Get Employees Period in Company as per Employee Joini

Basit Khan

9yAsked Aug 23, 2017, 7:15 AM929SQL

--How to Get Employees Period in Company as per Employee Joining Date

Example, I have a field

Emp_Number, Emp_Name, Emp_JoiningDate Period Start Period End

A-1 Alex 2013-07-14 2017-07-14 2018-07-14

A-2 Sachin 2017-08-14 2017-08-14 2018-08-14

Thanks

Basit

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Guest User9y ago
Hi,

check the below link, you will get an idea.

http://www.aspforums.net/Threads/143938/Calculate-employee-total-time-period-in-company-from-joining-date-to-end-date-in-SQL-Server/
0
Midhun Tp9y ago
Hi,

Please try below query -
SELECT Emp_Number,Emp_Name,Emp_JoiningDate,convert(DATE,convert(VARCHAR(4),YEAR(GETDATE()))+'-'+convert(VARCHAR(2),month(Emp_JoiningDate))+'-'+convert(VARCHAR(2),day(Emp_JoiningDate))) AS period_start
,convert(DATE,convert(VARCHAR(4),YEAR(GETDATE())+1)+'-'+convert(VARCHAR(2),month(Emp_JoiningDate))+'-'+convert(VARCHAR(2),day(Emp_JoiningDate))) AS period_start from tablename
0
Basit Khan9y ago
Many Thanks what about sql express 2008
0
Midhun Tp9y ago
Hi,

If you are using SQL server 2012 or higher, you can use below query -
SELECT Emp_Number,Emp_Name,Emp_JoiningDate,DATEFROMPARTS(YEAR(GETDATE()),month(Emp_JoiningDate),day(Emp_JoiningDate)) AS period_start,
DATEFROMPARTS(YEAR(GETDATE())+1,month(Emp_JoiningDate),day(Emp_JoiningDate)) AS period_end
0