Using date with month as 00 returns January

[former_SQLA_member1694978]

I am trying to use sa_rowgenerator and am seeing some odd behavior concerning dates.

SELECT dateformat ( cast ('1998/00/01' as date ), 'yyyy/mm/DD' ); <- Returns January 1, 1998
SELECT dateformat ( cast ('1998/01/01' as date ), 'YYYY/MM/DD' ); <- Returns January 1, 1998

My issue is that when I'm using the sa_rowgenerator for two months of different years (e.g. Dec 2018 - Jan 2019), I'm getting duplicates for January. Is there any way to turn off this behavior?

[Vlad]

Did you put MM and mm as month intentionally?

[VolkerBarth]

FWIW, with V16.0.0.2704, the first returns SQLCODE = -157 ("Cannot convert '1998/00/01' to a timestamp").

As stated in that (related?) FAQ, this seems to be a bug in v17. What version do you use?

[former_SQLA_member1694978]

I'm also using v17, which is likely where the issue is. Any ideas on when this will be fixed?

[VolkerBarth]

Hm, don't know as I'm just another customer – but I assume the SQL Anywhere folks like Mark will add details in the mentioned FAQ.

[Breck_Carter]