Forum Discussion

AlbertMaes's avatar
AlbertMaes
Regular Visitor
7 years ago
Solved

Java Long Date does not convert to time in query editor

Hi there,   new to the forum and new to data modelling...   I am connecting to a PostGres Database of our ticketing system (ManageEngine ServiceDesk) where timestamps are stored in what i assume ...
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi,@AlbertMaes

       You can add a calculate column when you modeling like this

    Date = DATEVALUE("1970-1-1") + (Table1[Column1]/(60*60*24*1000))

    Result:

     

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi,@AlbertMaes

   You can add a calculate column when you modeling like this

Date = DATEVALUE("1970-1-1") + (Table1[Column1]/(60*60*24*1000))

Result:

 

Best Regards,

Lin

AlbertMaes's avatar
AlbertMaes
Regular Visitor
7 years ago

Thank you Lin!  Works a treat!!