Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Isabelaa_123
Contributor II
Contributor II

how ConvertToLocalTime ?

Hello,

I have date in this format: 1675159200 corresponds to the date  2023-02-24 15:30.

The date should correspond to the zone Warsaw, but I don' know how do it.

 

I try function  converttolocaltime and localtime but it's bullshit. 

advice please 🙂

Labels (5)
1 Reply
Clever_Anjos
Employee
Employee

your number seems to be a Unix epoch 

 

The usual translation is 

timeStamp(
Makedate(1970,1,1)
+ 1675159200/24/60/60
, 'YYYY-MM-DD hh:mm:ss')