1. arkiboys Member

   How do I get the last day of the current month?
   

   arkiboys, Jun 4, 2008

   #2
2. FrankKalis Moderator

   DECLARE @dt datetime
   SELECT @dt = GETDATE()
   SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, @dt), 30)
   

   FrankKalis, Jun 4, 2008

   #3
3. Madhivanan Moderator

   or
   DECLARE @dt datetime
   SELECT @dt = GETDATE()
   SELECT DATEADD(MONTH, DATEDIFF(MONTH, 0, @dt)+1, -1)
   

   Madhivanan, Jun 4, 2008

   #4
4. johng New Member

   or
   if you need up to the last millisecond:
   DECLARE @dt datetime
   SELECT @dt = GETDATE()
   SELECT DATEADD(ms, -3, DATEADD(MONTH, DATEDIFF(MONTH, 0, GetDate()) + 1, 0))
   
   jg
   

   johng, Jun 4, 2008

   #5

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in