how to get first date of month in sql
  • how can i get first date of current month in sql.
  • 3 Comments sorted by
  • hi coder use this below query..

    select (dateadd(d,-(day(getdate()-1)),getdate()) ) First_Date_Of_Month
  • hi coder use this code..

    SELECT DATEADD(dd, -DAY(getdate()) + 1, getdate())
  • hi coder use this code..


    SELECT DATEADD(dd, -DAY(getdate()) + 1, getdate())

Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook

Popular Posts of the Week

Top Posters Weekly

Optimum Creative