How can I select the first day of a month in SQL?
Posted By: Anonymous
I just need to select the first day of the month of a given datetime variable.
I know it’s quite easy to do using this kind of code:
select CAST(CAST(YEAR(@mydate) AS VARCHAR(4))
+ '/' + CAST(MONTH(@mydate) AS VARCHAR(2)) + '/01' AS DATETIME)
But this is not very elegant, and probably not very fast either.
Is there a better way to do this? I’m using SQL Server 2008.
Solution
SELECT DATEADD(month, DATEDIFF(month, 0, @mydate), 0) AS StartOfMonth
Answered By: Anonymous
Related Articles
- How to return only the Date from a SQL Server…
- How to get the first and last date of the current year?
- SQL Server Group By Month
- Calculate time difference in minutes in SQL Server
- T-SQL datetime rounded to nearest minute and nearest…
- Get first day of week in SQL Server
- Log record changes in SQL server in an audit table
- AppCompat v7 r21 returning error in values.xml?
- Java string to date conversion
- Best approach to remove time part of datetime in SQL Server
- How to calculate age (in years) based on Date of…
- MS SQL Date Only Without Time
- Meaning of @classmethod and @staticmethod for beginner?
- Data structure for maintaining tabular data in memory?
- How to print a date in a regular format?
- Javascript add leading zeroes to date
- SMTP error 554
- How can I truncate a datetime in SQL Server?
- Converting between datetime, Timestamp and datetime64
- SQL statement to select all rows from previous day
- How to calculate age in T-SQL with years, months, and days
- How to increment datetime by custom months in python…
- polymer 1.0 dom-repeat filter only runs once
- get UTC timestamp in python with datetime
- Conversion failed when converting the varchar value…
- How do I get just the date when using MSSQL GetDate()?
- How to get week number of the month from the date in…
- How to obtain the start time and end time of a day?
- How to group by month from Date field using sql
- Subtract one day from datetime
- SQL NVARCHAR and VARCHAR Limits
- PostgreSQL: days/months/years between two dates
- data.table vs dplyr: can one do something well the…
- Ember.Object computed property returning an object
- type object 'datetime.datetime' has no attribute 'datetime'
- Difference between System.DateTime.Now and…
- How to determine the number of days in a month in…
- Polymer nested dom-repeat templates are not updating…
- Best way to do multi-row insert in Oracle?
- How to compare two dates to find time difference in…
- python pandas extract year from datetime: df['year']…
- A SELECT statement that assigns a value to a…
- How to query DATETIME field using only date in…
- Binding ComboBox SelectedItem using MVVM
- Webpack build error
- Convert Year/Month/Day to Day of Year in Python
- How to query for Xml values and attributes from…
- Don't let the user select a past date?
- SQL grouping by month and year
- Is resource nesting the only way to enable multiple…
- Persistent invalid graphics state error when using ggplot2
- Maximum size of a varchar(max) variable
- Get the last day of the month in SQL
- java.util.Date format conversion yyyy-mm-dd to mm-dd-yyyy
- NSDate get year/month/day
- SQL Server: Query fast, but slow from procedure
- How to add time to DateTime in SQL
- How do I convert a date/time to epoch time (unix…
- Generate SQL Create Scripts for existing tables with Query
- SQL Query to find the last day of the month
- Binding an ember model's date attribute to…
- Best way to find the months between two dates
- Aurelia, navigate is not updating viewport
- How to truncate milliseconds off of a .NET DateTime
- No function matches the given name and argument types
- "import datetime" v.s. "from datetime import datetime"
- Why does git perform fast-forward merges by default?
- Scripting Required for Polymer Submenu/Pages Navigation?
- Javascript, Time and Date: Getting the current…
- Best practices for SQL varchar column length
- G2Plot with nextjs. Stacked graph not working
- Using StringWriter for XML Serialization
- SQL Transaction Error: The current transaction…
- Conversion of a varchar data type to a datetime data…
- Reporting Services Remove Time from DateTime in Expression
- Using DateTime in a SqlParameter for Stored…
- How to get 2 digit year w/ Javascript?
- Why does `this` inside filter() gets undefined in VueJS?
- Calculating number of full months between two dates in SQL
- How to connect to local instance of SQL Server 2008 Express
- Nested ng-repeat
- How can I compare time in SQL Server?
- Drop all the tables, stored procedures, triggers,…
- The first day of the current month in php using…
- Converting dd/mm/yyyy formatted string to Datetime
- Ember router: how to use transitionTo
- How to convert number of minutes to hh:mm format in TSQL?
- How do I turn a C# object into a JSON string in .NET?
- Return datetime object of previous month
- SQL Server: convert ((int)year,(int)month,(int)day)…
- How do I properly set the Datetimeindex for a Pandas…
- Get week day name from a given month, day and year…
- Calculate last day of month in JavaScript
- Getting the difference between two Dates…
- Memcached vs. Redis?
- SQL Server Group by Count of DateTime Per Hour?
- Should MySQL have its timezone set to UTC?
- Print all day-dates between two dates
- How to get previous month and year relative to…
- Python timedelta in years
Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.
