When used 'weeks' interval, date in sqlite were formatted with '%%Y-%%W', so for date '2013-04-05' it gives '2013-13'
Later, this string is parsed as date, and it fails complaing there is no 13th month.
Other engines return date truncated by week, for example '2013-04-05' gives '2013-04-01', so it gets successfully parsed.
Hi,
Could you please provide more details: why does this change fixes
#7? I'm asking because I can't reproduce#7myself and there are no failing tests.When used 'weeks' interval, date in sqlite were formatted with '%%Y-%%W', so for date '2013-04-05' it gives '2013-13' Later, this string is parsed as date, and it fails complaing there is no 13th month.
Other engines return date truncated by week, for example '2013-04-05' gives '2013-04-01', so it gets successfully parsed.
I attached additional test for this issue
This make sense. Many thanks!