Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • SQL Server : Useful datetime functions to find specific dates

    @vikram.kashyap
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 600
    Comment on it

    Following are some useful SQL Server Date functions to find specific dates.

    1) Today

    SELECT GETDATE() 'Today'

    2) Yesterday

    SELECT DATEADD(d,-1,GETDATE()) 'Yesterday'

    3) First Day of Current Week

    SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) 'First_Day_Current_Week'

    4) Last Day of Current Week

    SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) 'Last_Day_Current_Week'

    5) First Day of Last Week

    SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0) 'First_Day_Last_Week'

    6) Last Day of Last Week

    SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),6) 'Last_Day_Last_Week'

    7) First Day of Current Month

    SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0) 'First_Day_Current_Month'

    8) Last Day of Current Month

    SELECT DATEADD(ms,- 3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE())+1,0))) 'Last_Day_Current_Month'

    9) First Day of Last Month

    SELECT DATEADD(mm,-1,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)) 'First_Day_Last_Month'

    10) Last Day of Last Month

    SELECT DATEADD(ms,-3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))) 'Last_Day_Last_Month'
    SQL SQL Server
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: