1640673286 convert to date time

[renri]

how can I convert to date time by function for 1640673286

[Chanty4u]

try this way

LOAD Timestamp(Timestamp#(YOURFIELD,'YYYYMMDDhhmm'),'MM/DD/YYYY hh:mm:ss TT') as TIMESTAMP,

or

It would be better to split your timestamp filed into two separate date and time fields as this will use less memory in the app.

date(date#( 'Field' , 'YYYYMMDDhhmmss'), 'DD.MM.YYYY')  as date

time(date#( 'Field' , 'YYYYMMDDhhmmss'), hh:mm:ss) as time

[Vegar · Accepted solution]

I assume this is an UNIX formated time, the number of seconds since January 1th 1970. 

Try converting it to a Qlik recognised  date by using this function. 

=TimeStamp(MakeDate(1970,1,1) + [Your datetime field]/24/60/60) as [Your timestamp]

or even simpler

=TimeStamp(MakeDate(1970) + [Your datetime field]/86400) as [Your timestamp]

[renri]

This method is prefect. Thanks.

[renri]

1640673286 is a UNIX timestamp,I didn't succeed in this method.Thanks.best wish for you.