topic Re: DB2 time converter in QlikView https://community.qlik.com/t5/QlikView/DB2-time-converter/m-p/737066#M1054602 <HTML><HEAD></HEAD><BODY><P>Thankyou <STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/tresesco">tresesco</A></STRONG> <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 31 Oct 2014 05:36:36 GMT noman212 2014-10-31T05:36:36Z DB2 time converter https://community.qlik.com/t5/QlikView/DB2-time-converter/m-p/737064#M1054600 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P>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&nbsp; feild the data type of that feild in DB2 is Integer. and values save in DB2 in following pattern "1398866672". </P><P>How can i convert this time feild to datetime? </P></BODY></HTML> Fri, 31 Oct 2014 05:07:38 GMT https://community.qlik.com/t5/QlikView/DB2-time-converter/m-p/737064#M1054600 noman212 2014-10-31T05:07:38Z Re: DB2 time converter https://community.qlik.com/t5/QlikView/DB2-time-converter/m-p/737065#M1054601 <HTML><HEAD></HEAD><BODY><P>Check if this helps: <A href="https://community.qlik.com/thread/124066">Unix timestamp from a string to date</A></P></BODY></HTML> Fri, 31 Oct 2014 05:10:14 GMT https://community.qlik.com/t5/QlikView/DB2-time-converter/m-p/737065#M1054601 tresB 2014-10-31T05:10:14Z Re: DB2 time converter https://community.qlik.com/t5/QlikView/DB2-time-converter/m-p/737066#M1054602 <HTML><HEAD></HEAD><BODY><P>Thankyou <STRONG style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/tresesco">tresesco</A></STRONG> <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Fri, 31 Oct 2014 05:36:36 GMT https://community.qlik.com/t5/QlikView/DB2-time-converter/m-p/737066#M1054602 noman212 2014-10-31T05:36:36Z