Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need add the hours to a time format when the time is the summertime or wintertime.
I have this:
Timestamp |
04.05.2020 05:30:00 |
30.11.2020 20:15:00 |
I need to get this format:
Time |
05:30:00+01:00 |
20:15:00+02:00 |
The timezone is always berlin.
Thanks for your help!
Hi @alexandermllr , here you have an example, i assume that the date is not valid so i had to convert it.
And if you have valid timestamp values, yuo just have to ask for the month, you know hich are the months for differents timezones. I wrote this as example Hour & ' ' & if(month(Date2)<5, '+1', '+2') as Hour;
Data:
LOAD * INLINE [
Timestamp
04.05.2020 05:30:00
30.11.2020 20:15:00
];
Load
Timestamp,
Date2 as Date,
Hour & ' ' & if(month(Date2)<5, '+1', '+2') as Hour;
Load
*,
makedate(subfield(Date, '.', 3),subfield(Date, '.', 2),subfield(Date, '.', 1)) as Date2;
Load
Timestamp,
subfield(Timestamp, ' ', 1) as Date,
subfield(Timestamp, ' ', 2) as Hour
Resident Data;
drop table Data;
exit script;