Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Just noticed this.
Issue:
Unless I'm way off here! Which is a possibility!
Thank you
Solved! Go to Solution.
Explain again why converting:
2017-11-01T12:00:00.000Z
Which is clearly November 1st, 2017 should convert to October 31st again?
Explain again why converting:
2017-11-01T12:00:00.000Z
Which is clearly November 1st, 2017 should convert to October 31st again?
Hi @Greg_Deckler. I messed up! I was reading the string 2017-11-01T12:00:00.000Z, as ...12:00:00AM. After changing data type to Date/Time, the new value, of 11/01/2017 05:00:00AM looked like "midnight minus 7 hours" but still on the same day (rather than moving to the previous day).
What I should have realized, is that ...12:00:00 is midday on a 24hr. time scale, NOT midnight. My mistake.
Thank you for the reply!
On this note though... how do I control the translation when moving from a STRING to DATE/TIME data type? I ask because this particular column of data has time info from MULTIPLE timezones, but the translation is blanket. It changes ALL times to my local computers time.
Thank you
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |