Getting Started with Adobe After Effects - Part 6: Motion Blur
This module helps you to share, discuss and learn interview questions and answers of different technologies

How to find out last day of month?

Oct 20 2011 2:50AM by Madhivanan   

Question

How will you find out the last day of the current month?

Answer

select dateadd(month,datediff(month,0,getdate())+1,-1)

The logic is to find out number of months from base date (1900, jan 01) and add 1 the result to base date itself and subtract one day.

Read More..   [0 clicks]

Published under: SQL Server Interview Questions ·  ·  ·  · 


Madhivanan
3 · 40% · 12862
0
Liked
 
0
Asked



Submit

Your Comment


Sign Up or Login to post a comment.

"How to find out last day of month?" rated 5 out of 5 by 1 readers
How to find out last day of month? , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]