how to display 24 fortnight in sql server.

Question

how to display 24 fortnight in sql server. e.g 01 jan-15 jan --1 st fortnight 16 jan -last day of month --2 nd fortnight 01 feb-15 feb--3rd fortnight 16 feb-last day of month --4th fortnight till december

Ankit Sharma · Answer

Hi Krunal The below code will give the fortnight number of todays date. Please modify it as per your need declare @yearbegin datetime declare @diff integer set @yearbegin = DATEADD( year  DATEDIFF( year  0 GETDATE()) 0) --First day of current year print @yearbegin set @diff=DATEDIFF( day @yearbegin GETDATE()) print (@diff/15)+1 Hope this helps