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? asked 15 Jan '19, 13:48 Dan Volker Barth |
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? answered 16 Jan '19, 03:52 Volker Barth 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?