Skip to content
This repository has been archived by the owner on Jan 28, 2021. It is now read-only.

yearweek function #616

Closed
erizocosmico opened this issue Feb 12, 2019 · 2 comments
Closed

yearweek function #616

erizocosmico opened this issue Feb 12, 2019 · 2 comments
Assignees
Labels

Comments

@erizocosmico
Copy link
Contributor

https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_yearweek

@theodesp
Copy link
Contributor

theodesp commented Feb 21, 2019

This is tricky as for example

mysql> SELECT YEARWEEK('1987-01-01');
        -> 198652

If we use the following ISOWeek method
https://play.golang.org/p/I6IbIHRqSaf

It will print 1987 for year and 1 for week. I don't know if its a bug or a feature

@theodesp
Copy link
Contributor

@kuba-- kuba-- self-assigned this Mar 1, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
Projects
None yet
Development

No branches or pull requests

3 participants