on 2021 Dec 23 5:14 AM
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...
Request clarification before answering.
User | Count |
---|---|
52 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.