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? |
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? I'm also using v17, which is likely where the issue is. Any ideas on when this will be fixed?
(16 Jan '19, 09:30)
Dan
Replies hidden
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.
(16 Jan '19, 11:40)
Volker Barth
|
Did you put MM and mm as month intentionally?