If you want to get the first day of the month of a input datetime variable from a SQL Query , here’s how you do it.
SELECT DATEADD(month, DATEDIFF(month, 0, GetDate()), 0) AS StartMonthDate
How to get the first day of the month in SQL Server ?
Published on September 6, 2016 by abundantcode
Filed under SQL Server
Last modified September 6, 2016
Print this pageThis article have been viewed 3719 times
Subscribe
How to decode a base64 string in C#?
March 10, 2017How to disable editing of items in a combo box in c#?
March 10, 2017How to get the AM or PM value from a DateTime object in C# ?
March 10, 2017C# program to print the multiplication table of a given number.
March 10, 2017Productivity Power Tools for Visual Studio 2017
March 8, 2017Visual Studio 2017 Launch and 20th Anniversary Event: Application Development
March 7, 2017C# Program to swap two numbers without using temporary variable
March 5, 2017C# Program to swap two numbers
March 5, 2017C# Program to print the sum of two numbers
March 5, 2017C# Program to find the ASCII Value of a Character
March 4, 2017
15 Best ASP.NET based Content Management Systems(CMS)
March 10, 2013How to Remove Duplicates and Get Distinct records from List using LINQ?
August 9, 2013How to send SMS in Windows Phone 8 Programatically using C#?
October 29, 2013Top Tools to Convert HTML to PDF in .NET
December 27, 2013Open Source ASP.NET ecommerce Projects
April 8, 2013How to Populate the DropDownList in ASP.NET MVC Razor View?
April 25, 2013How to Auto Refresh webpage every 5 seconds in PHP?
July 7, 2013How to Get the Max Value from a List of Integer using LINQ Query in C#?
July 28, 20135 Alternative ASP.NET MVC View Engines
March 12, 2013Retrieve Data from the Request Object in ASP.NET MVC
April 30, 2013
.NET 101 Samples Angular 2 App Array ASP.NET ASP.NET MVC C# C# programs Collection convert csharp database download Example F# File guide How to How to in Java integer Java Javascript Lambda LINQ List Silverlight SQL Server string tips tricks tutorial tutorials UWP video visual studio 2015 Windows Windows 8 Windows 10 Windows Phone Windows Phone 8 Windows Phone 8.1 wp8 wpdev XAML
Categories
Tags
.NET 101 Samples Angular 2 App Array ASP.NET ASP.NET MVC C# C# programs Collection convert csharp database download Example F# File guide How to How to in Java integer Java Javascript Lambda LINQ List Silverlight SQL Server string tips tricks tutorial tutorials UWP video visual studio 2015 Windows Windows 8 Windows 10 Windows Phone Windows Phone 8 Windows Phone 8.1 wp8 wpdev XAML
Leave a Comment