[Info-vax] EU will abandon daylight savings time in 2021

[Jan-Erik Söderholm]

Den 2019-04-04 kl. 03:27, skrev Arne Vajhøj:
> On 4/3/2019 1:37 PM, Jan-Erik Söderholm wrote:
>>                        We have some local timestamps that has to be
>> converted to GMT/UTC before sent to another system, and these are both
>> from "winter time" and "summer time". We can of course hardcode the
>> dates for the switches and compare, but it would be nice if the rule
>> could be used...
> 
> What do you have and what do you need to convert it to?

An INTEGER "date" with format YYYYMMDD, ag 20190404 for today.

A SMALLINT "time" with format HMM or HHMM, range from 1 (one minute
after midnight) to 2359 (one minute before midnight). I guess
it could be zero also for the first minute after midnight, but
the system is having it's night-batch windows then.

These two are in Swedish local time (winter or summer time).

The target system uses Unix Epoch format (seconds since some date).

> 
> When I hear timestamp I would typical suspect that you
> already have seconds or milliseconds since epoch UTC.
> But if that is the case then you already have UTC
> and do not need to convert. So.
> 
> Do you have a VMS 64 bit local time and need to convert
> it to seconds or milliseconds since epoch UTC?
> 

No "date" type variables at all, just integers. But newer tables
gets proper timestamp type variables.

> Or?
> 
> Arne
> 
>