DB2 time converter

[noman212]

Hello Friends,

i am using IBM DB2 to get the records but in DB2 i have a feild name F_CREATETIME which stores date and time DB2 i load the script in Qlikview then i make qvd of table but qlikview not supported time format of F_CREATETIME  feild the data type of that feild in DB2 is Integer. and values save in DB2 in following pattern "1398866672".

How can i convert this time feild to datetime?

[tresesco · Accepted solution]

Check if this helps: Unix timestamp from a string to date

[noman212]

Thankyou tresesco