What is the SQL syntax to convert a Date with hours and minutes into the first day of its month?

Question

I am using SQL Server 2012 and I have a column called Created in one of my tables.

The Created column has dates in the datetime format: 2014-02-08 14:01:20.347

I need to convert the dates into the following format. For example, if date is 2014-02-08 14:01:20.347, then I need it to become 2014-02-01 00:00:00.000

How can I achieve this?

score 2 · Accepted Answer · answered Aug 09 '18 at 11:59

2

I would use datefromparts():

select datefromparts(year(created), month(created), 1)

answered Aug 09 '18 at 11:59

Gordon Linoff

1,242,037
58
646
786

score 1 · Answer 2 · answered Aug 09 '18 at 12:02

1

SELECT DATEADD(month, DATEDIFF(month, 0, date_column), 0)

answered Aug 09 '18 at 12:02

akshay

777
4
15

What is the SQL syntax to convert a Date with hours and minutes into the first day of its month?

2 Answers2