How to get current week number for that year from a date in MySQL?

Question

In MySQL,

SELECT WEEK('2019-01-07')

is showing week number 1.

But if I see, 2019 starts from Tuesday and current week for that date is week number 2.

How can I get the current week according to the year in this way?

See the manual under the relevant function. – Strawberry Feb 01 '19 at 14:07 — Strawberry, Feb 01 '19 at 14:07

score 2 · Accepted Answer · edited Feb 01 '19 at 15:57

2

Maybe you need WEEKOFYEAR function:

SELECT WEEKOFYEAR('2019-01-07'); # returns 2

edited Feb 01 '19 at 15:57

oniramarf

answered Feb 01 '19 at 15:48

Mohan J Poola

1 Answers1