Go from Local Time to UTC with respect to the dates I have!

Question

Daphne PARLIARI 2020-3-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/511140-go-from-local-time-to-utc-with-respect-to-the-dates-i-have

评论： Star Strider 2020-3-16

Date-Time.xlsx

Hi guys, I need your expertise on that.

I have a column with dates and time (see attached) which is in Local Time Zone (Europe/Athens) and I want to convert it to UTC. I know this is pretty straight forward but the problem lies here:

If you notice on the attached .xlsx, arrows between 25103 and 25104 are missing the date 29-Mar-2015 03:00:00. That is because the weather station was using Daylight Saving Time for the entire year (UTC+0300), and I tried to change that and keep UTC+0200 for wintertime. Therefore I missed 29-Mar-2015 04.00 (which was the time that Greece changed from UTC+0200 to UTC+0300) and I have a double entry for 25-Oct-2015 03.00 ( (which was the time that Greece changed from UTC+0300 to UTC+0200).

When I try to go from LT to UTC with

LT.TimeZone = 'UTC';

I am losing information about the two errorous dates I mentioned (29-Mar-2015 03:00:00 and 25-Oct-2015 03.00). Which means that I am creating a column with all dates starting from 31/12/2014 21.00 to 31/12/2015 22.00.

Is there a solution to my problem? I would appreciate your thoughts...

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Star Strider 2020-3-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/511140-go-from-local-time-to-utc-with-respect-to-the-dates-i-have#answer_420384

在 MATLAB Online 中打开

The data in your Excel file need a bit of preprocessing, then the conversion is straightforward:

D = readtable('Date-Time.xlsx','ReadVariableNames',0);
D.Var1 = datetime(strrep(D.Var1, '''', ''), 'TimeZone','Europe/Athens');

then to do the conversion:

Original = D.Var1(1:5,:)                                                    % Information Only (Delete)
D.Var1.TimeZone = 'UTC';
New = D.Var1(1:5,:)                                                         % Information Only (Delete)

producing:

Original = 
  5×1 datetime array
   31-Dec-2014 23:00:00
   31-Dec-2014 23:00:00
   31-Dec-2014 23:00:00
   31-Dec-2014 23:00:00
   31-Dec-2014 23:00:00
New = 
  5×1 datetime array
   31-Dec-2014 21:00:00
   31-Dec-2014 21:00:00
   31-Dec-2014 21:00:00
   31-Dec-2014 21:00:00
   31-Dec-2014 21:00:00

7 个评论
显示 5更早的评论隐藏 5更早的评论

Star Strider 2020-3-16

编辑：Star Strider 2020-3-16

在 MATLAB Online 中打开

Then either delete it or assign NaN to the variables associated with it. The time lost ot the transitions from Standard Time to Daylight Time are lost forever. The opposite transition creates duplicated times.

If you simply want to subtract two hours from the weather station time (since it was on Daylight Time the entire year), just subtract two hours (or whatever the correct conversion is) from the weather station time:

D = readtable('Date-Time.xlsx','ReadVariableNames',0);
D.Var1 = datetime(strrep(D.Var1, '''', ''), 'TimeZone','Europe/Athens');
Original = D.Var1(1:5,:)                                                    % Information Only (Delete)
D.Var1 = D.Var1 - hours(2);
New = D.Var1(1:5,:)                                                         % Information Only (Delete)

With that, there is no transition:

Check = D.Var1(25122:25132)

produces:

Check = 
  11×1 datetime array
   29-Mar-2015 02:00:00
   29-Mar-2015 02:00:00
   29-Mar-2015 02:00:00
   29-Mar-2015 02:00:00
   29-Mar-2015 02:00:00
   29-Mar-2015 02:00:00
   29-Mar-2015 04:00:00
   29-Mar-2015 04:00:00
   29-Mar-2015 04:00:00
   29-Mar-2015 04:00:00
   29-Mar-2015 04:00:00