cancel
Showing results for 
Search instead for 
Did you mean: 

How to convert a UTC timestamp to a named timezone in SAP SQL Anywhere?

4,065

I'm using SQL Anywhere 17 and have a timestamp (without time zone) which I know is UTC, and I know that my client's browser reports a timezone of "Europe/Berlin".

Is there an easy way to convert the UTC timestamp using SQL? Let's assume that I have already created the timezone with

CREATE TIME ZONE "Europe/Berlin" OFFSET '01:00'  DST OFFSET '01:00' DST STARTING 'Mar/last Sun' AT '02:00' DST ENDING 'Oct/last Sun' AT '02:00';

I've not yet found a system function to do that. Doing it manually using SYSTIMEZONE is quite some work, with the risk of overlooking one of the special cases...

Accepted Solutions (0)

Answers (0)