topic Timestamp Hour Conversion in QlikView https://community.qlik.com/t5/QlikView/Timestamp-Hour-Conversion/m-p/1407800#M803605 <HTML><HEAD></HEAD><BODY><P>Is there a specific QV function that will convert&nbsp; Hour(timestamp) using the formatted timestamp value of 20171116T080348.000-0700 to 8 rather than 15? Or do I need to parse the '-700' out first?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT mpressey 2020-11-25T16:16:04Z Timestamp Hour Conversion https://community.qlik.com/t5/QlikView/Timestamp-Hour-Conversion/m-p/1407800#M803605 <HTML><HEAD></HEAD><BODY><P>Is there a specific QV function that will convert&nbsp; Hour(timestamp) using the formatted timestamp value of 20171116T080348.000-0700 to 8 rather than 15? Or do I need to parse the '-700' out first?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Timestamp-Hour-Conversion/m-p/1407800#M803605 mpressey 2020-11-25T16:16:04Z Re: Timestamp Hour Conversion https://community.qlik.com/t5/QlikView/Timestamp-Hour-Conversion/m-p/1407801#M803606 <HTML><HEAD></HEAD><BODY><P>look at ConvertToLocalTime function</P></BODY></HTML> Thu, 16 Nov 2017 19:14:37 GMT https://community.qlik.com/t5/QlikView/Timestamp-Hour-Conversion/m-p/1407801#M803606 m_woolf 2017-11-16T19:14:37Z Re: Timestamp Hour Conversion https://community.qlik.com/t5/QlikView/Timestamp-Hour-Conversion/m-p/1407802#M803607 <HTML><HEAD></HEAD><BODY><P>Thank you.</P></BODY></HTML> Thu, 16 Nov 2017 19:21:23 GMT https://community.qlik.com/t5/QlikView/Timestamp-Hour-Conversion/m-p/1407802#M803607 mpressey 2017-11-16T19:21:23Z