https://community.qlik.com/t5/QlikView/Date-and-Time-Cast/m-p/209304#M1209093 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I want to know how to make QV to understand my Movex DB2 Date and Time formats.<BR />In Movex is the Date format is in one column in YYYYMMDD style and the time format in another column in HHMMSS style.</P><P>The thing is that an normal date and time is 20100115 154700 but when the time is 1 sec over midnigt then the time is only displayed as '1' ('YYYYMMDD' as date style byt only 'S' as timestyle instead of 'HHMMSS')<BR /><BR />I have been using normal T-sql but I need to know how it is done in QV.<BR />To solve this in T-SQL<BR />timestamp(CONCAT(DATEFIELD, right(digits(TIMEFIELD),6)))<BR /><BR />QV don't seems to handle the "DIGITS" function.<BR /><BR />I have tested with Date / Time / cast functions with no success.<BR /><BR />Thanx in advance for any replies</P><P>// Daniel</P></BODY></HTML> Wed, 20 Jan 2010 17:51:39 GMT 2010-01-20T17:51:39Z https://community.qlik.com/t5/QlikView/Date-and-Time-Cast/m-p/209304#M1209093 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I want to know how to make QV to understand my Movex DB2 Date and Time formats.<BR />In Movex is the Date format is in one column in YYYYMMDD style and the time format in another column in HHMMSS style.</P><P>The thing is that an normal date and time is 20100115 154700 but when the time is 1 sec over midnigt then the time is only displayed as '1' ('YYYYMMDD' as date style byt only 'S' as timestyle instead of 'HHMMSS')<BR /><BR />I have been using normal T-sql but I need to know how it is done in QV.<BR />To solve this in T-SQL<BR />timestamp(CONCAT(DATEFIELD, right(digits(TIMEFIELD),6)))<BR /><BR />QV don't seems to handle the "DIGITS" function.<BR /><BR />I have tested with Date / Time / cast functions with no success.<BR /><BR />Thanx in advance for any replies</P><P>// Daniel</P></BODY></HTML> Wed, 20 Jan 2010 17:51:39 GMT https://community.qlik.com/t5/QlikView/Date-and-Time-Cast/m-p/209304#M1209093 2010-01-20T17:51:39Z https://community.qlik.com/t5/QlikView/Date-and-Time-Cast/m-p/209305#M1209094 <HTML><HEAD></HEAD><BODY><P>Have a look at the function num(), for example:</P><P>num(QORGTM, 000000)</P><P></P></BODY></HTML> Wed, 20 Jan 2010 18:05:02 GMT https://community.qlik.com/t5/QlikView/Date-and-Time-Cast/m-p/209305#M1209094 2010-01-20T18:05:02Z https://community.qlik.com/t5/QlikView/Date-and-Time-Cast/m-p/209306#M1209095 <HTML><HEAD></HEAD><BODY><P>Also look at the date#() and time#() functions. They read a date/time with the format you give it.</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />date#(DATEFIELD, 'YYYYMMDD') AS ...<BR />time#(TIMEFIELD,'HHMMSS') AS ...<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>Or put them together to get a complete date field.</P></BODY></HTML> Wed, 20 Jan 2010 18:58:08 GMT https://community.qlik.com/t5/QlikView/Date-and-Time-Cast/m-p/209306#M1209095 2010-01-20T18:58:08Z