CODEWITHSUNDEEP
sqlsql-server
redconservatory
redconservatory

Reputation: 21924

MS SQL select a datetime by month?

How do you select a datetime column by month?

TABLE A
TITLE   MY_DATETIME   
blah    2011-03-26 05:44:43.213

SELECT * 
FROM TABLE A
WHERE MY_DATETIME = "August"

Upvotes: 12

Views: 45185

Answers (4)

David Gonzalez
David Gonzalez

Reputation: 771

Other option:

CONVERT(VARCHAR(10), My Date, 23) like '2020-10-%'

Upvotes: 0

Oki Erie Rinaldi
Oki Erie Rinaldi

Reputation: 1863

I use EXTRACT function instead of DATEPART. DATEPART function doesn't exist in my mysql.

Upvotes: 1

Stuart Ainsworth
Stuart Ainsworth

Reputation: 12940

SELECT *
FROM TABLE A
WHERE DATENAME(MONTH, MY_DATETIME) = 'August'

Upvotes: 0

gbn
gbn

Reputation: 432190

SELECT * 
FROM TABLE A
WHERE DATEPART(month, MY_DATETIME) = 8

Or, less reliably based on language setting:

...
WHERE DATENAME(month, MY_DATETIME) = 'August'

Upvotes: 25

Related Questions