Back
I want to get the last day of a month in the below format:
"2013-05-31 00:00:00:000"
Can anyone help me out?
You can try the following code:
CREATE FUNCTION [dbo].[udf_GetLastDayOfMonth] ( @Date DATETIME ) RETURNS DATETIME AS BEGIN RETURN DATEADD(d, -1, DATEADD(m, DATEDIFF(m, 0, @Date) + 1, 0)) END
Query:
DECLARE @date DATETIME SELECT @date = '2013-05-31 15:04:10.027' SELECT DATEADD(d, -1, DATEADD(m, DATEDIFF(m, 0, @date) + 1, 0))
Output:
----------------------- 2013-05-31 00:00:00.000
Willing to Learn SQL? Sign up for the SQL course by Intellipaat to clear the SQL certification exam.
31k questions
32.8k answers
501 comments
693 users