I have a Couchbase installation (5.1) and am trying to convert dates between timezones. However, Couchbase cannot find the timezones based on the timezone names and is returning null.
SELECT STR_TO_TZ(‘2018-10-10T12:00:00Z’, ‘America/New_York’) as EST, STR_TO_TZ(‘2018-10-10T12:00:00Z’, ‘UTC’) as UTC;
I understand that I am probably missing ta TZ_DATA file, but am not sure how/where to install this under Windows. Can anyone provide advice?