none
UnixTimestamp RRS feed

  • Question

  • Hi,

    I am using PowerQuery to get Data from a Json File. One of my columns has UnixTimeStamp Dates. I would like to add a new column in PowerQuery in which the Date is calculated as a "normal" Date,Time Value.

    Thank you

    Best Regards,

    Bernd

    Example:

    1392370800 equates 14.02.2014 10:40:00

    • Edited by BerndSPL Wednesday, April 2, 2014 10:07 AM
    Wednesday, April 2, 2014 9:46 AM

Answers

  • I'm afraid I wasn't able to find a good way to resolve the summer time issue. I've started an investigation for what we can do to improve time zone-related stuff.
    • Marked as answer by BerndSPL Thursday, April 3, 2014 7:04 AM
    Wednesday, April 2, 2014 5:28 PM

All replies

  • It would be something like

    #datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, 1392370800)

    This gives a result an hour off one hour from yours; there may be some fiddling required with timezones if you need to make daylight savings time (aka summer time) work out. Is your value in a specific timezone?


    Wednesday, April 2, 2014 11:52 AM
  • Hello Curt,

    Thank you for your answer - it worked perfect.

    But, as you mentioned, some dates are summer time.

    The dates are from Austria Central European Time (CET).

    Thx

    Wednesday, April 2, 2014 1:30 PM
  • I'm afraid I wasn't able to find a good way to resolve the summer time issue. I've started an investigation for what we can do to improve time zone-related stuff.
    • Marked as answer by BerndSPL Thursday, April 3, 2014 7:04 AM
    Wednesday, April 2, 2014 5:28 PM
  • No worries - I found a way to get the data exported to the json file in a normal date/time format. Unfortunatly it was a big workaround. I think having something that differentiate between TimeZone-  SummerTime/WinterTime would be great!

    Thursday, April 3, 2014 7:04 AM