I’m using function "MILLIS_TO_ZONE_NAME() " in couchbase 4.5. But now I want upgrade my couchbase to Community Edition 5.0.1 build 5003. Problem is that function, that was working well in couchbase 4.5, now have problem. Function executed with status success, but result is null. I did some experiments with this function and I detect a bug. Function work well, when argument tz have value UTC, but any other values of tz cause that result is null. In documentation is example with tz argument (‘America/New_York’, ‘Asia/Kolkata’, ‘UTC’). Just one example is running well, that one where tz value is ‘UTC’. I found nothing to this bug, so I want ask you, if I write something wrong or it is bug. And what I must do, if I want use this function.
Here is example, that I’m running:
“SELECT MILLIS_TO_TZ(1463284740000, ‘America/New_York’) as zonetime”
And result is: