The time zone offset is denoted with +01:00/+02:00 at the end. Is there a generic timezoneinfo for central europe that takes into consideration both cet and cest into one? Oracle does not provide any function like at summer time for timestamps.
Vyvan Le (vyvan.le)
Add 1 hour from last october sunday add 2 hours from last march sunday query sample select name,. So i thought that the microsoft. I have an app that is doing the following:
Another detail is that cet is an ambiguous name, because it's used by more than one timezone.
For your requested zones, the ids are: However, i get the problem that the utc. Is it possible to convert oracle utc to cet or cest timestamp, i.e. There are a lot of countries which change from cet (central european time) to cest (central european summer time) during dst (daylight saving time).
I have a function that converts the date, resolution and position to a datetime, which i then set to the requisite time zone, from which i convert to utc. Real timezones names use the ones defined by iana database (always in the format. Either you use fixed time zones like cet or +01:00 or +02:00 or you use the time zone region, e.g. I have a dataset containing a datetime character column, in cest/cet time zone (central europe local time).
