SQL: how to extract the month from a date time field [duplicate]

Question

I need to to extract the month from date time fieldA then put the result into fieldB as an integer in the same table IF fieldB is empty.

eg) 1988-02-03 00:00:00.000 I need to extract 02 and put the result into another field only if that field is empty.

I guess this will end up as a stored procedure.

"I need to extract 02" section is unclear, you;re updating two fields on any condition? — Sunny
– Sunny, Commented Mar 6, 2013 at 17:52
The answer here is more complete than the proposed duplicate question as it also covers how to update fields and check for empty fields. — mechalaris
– mechalaris, Commented Mar 7, 2013 at 11:31

KyleMit · Accepted Answer · 2013-10-29 19:24:52Z

8

Use MONTH()

UPDATE your_table SET some_column = MONTH(date_column) WHERE some_column IS NULL

edited Oct 29, 2013 at 19:24

KyleMit♦

31.4k74 gold badges517 silver badges712 bronze badges

answered Mar 6, 2013 at 17:51

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

swasheck Over a year ago

... assuming that the 02 is actually the month and that the date format isn't YYYY-DD-MM

Infinite Possibilities · Accepted Answer · 2013-03-06 17:51:12Z

1

MONTH(fieldA) or DATEPART(M, fieldA)

answered Mar 6, 2013 at 17:51

Infinite Possibilities

5773 silver badges11 bronze badges

Comments

marc_s · Accepted Answer · 2013-03-06 19:43:02Z

1

SQL Server has a built-in function called month() that will return the month for date and timestamp data types

UPDATE yourtable SET newcolumn = month(columnname) WHERE newcolumn IS NULL

edited Mar 6, 2013 at 19:43

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Mar 6, 2013 at 17:51

Matt Busche

14.4k5 gold badges38 silver badges63 bronze badges

2 Comments

marc_s Over a year ago

It will not work on timestamp datatypes, since those don't really represent an actual date per se ....

ypercubeᵀᴹ Over a year ago

As @marc_s commented, timestamp is not date or datetime. The name was such a huge confusion that they are deprecating it: The timestamp syntax is deprecated. This feature will be removed in a future version of Microsoft SQL Server.*

Collectives™ on Stack Overflow

SQL: how to extract the month from a date time field [duplicate]

3 Answers 3

1 Comment

Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Linked

Related