Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Converting a timestamp to a date

Hi,

I didn't find out in the post a solution of this issue.

I have a file with a date in timestamp in seconds.

I'd like to display the date in format 'YYYY-MM-DD'.

How ?

Thanks for any help

JJJ

13 Replies
Not applicable
Author

Héctor, the website is not accessable any more

marcelo_7
Creator
Creator

I have a timestamp 1141146494. When I use the function FROM_UNIXTIME(Time) it returns 2006-02-28 18:08:14 but the timestamp solution you proposed returns 2006-02-28 17:08:14. What am I missing?

Update: it seems Online Conversion - Unix time conversion says the same thing your function does so I assume the SQL function is at fault. Thanks!

perla_chirag
Contributor III
Contributor III

Thanks Yves!

Was looking for this conversion

menta
Partner - Creator II
Partner - Creator II

May be the changing to legal time?