https://community.qlik.com/t5/QlikView/Add-2-hours-to-a-timestamp/m-p/1745890#M453309 <P>Thank you very much <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/56648">@Taoufiq_Zarra</a> !!! helped me a lot</P> Tue, 22 Sep 2020 08:49:09 GMT jisephcirspy 2020-09-22T08:49:09Z https://community.qlik.com/t5/QlikView/Add-2-hours-to-a-timestamp/m-p/1745842#M453306 <P>Hello,</P><P>&nbsp;</P><P>I want to add 2 hours to a timestamp (I cannot change it in the database).</P><P>The timestamp looks like this 2020-09-22 06:30:02.000000 (YYYY-MM-DD hh:mm:ss.miliseconds)</P> Sat, 16 Nov 2024 18:04:56 GMT https://community.qlik.com/t5/QlikView/Add-2-hours-to-a-timestamp/m-p/1745842#M453306 jisephcirspy 2024-11-16T18:04:56Z https://community.qlik.com/t5/QlikView/Add-2-hours-to-a-timestamp/m-p/1745854#M453307 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/121194">@jisephcirspy</a>&nbsp; like :</P><LI-CODE lang="python">=timestamp(Date#('2020-09-22 06:30:02.000000','YYYY-MM-DD hh:mm:ss.ffffff') + 2/24)</LI-CODE><P>&nbsp;</P><P>Example : 2020-09-22 06:30:02.000000</P><P>output:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 643px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/40975i3600DC6C6F95B806/image-size/large?v=v2&amp;px=999" role="button" title="Capture.PNG" alt="Capture.PNG" /></span></P><P>2/24-&gt; Nbofhour/24</P><P>&nbsp;</P> Tue, 22 Sep 2020 07:47:19 GMT https://community.qlik.com/t5/QlikView/Add-2-hours-to-a-timestamp/m-p/1745854#M453307 Taoufiq_Zarra 2020-09-22T07:47:19Z https://community.qlik.com/t5/QlikView/Add-2-hours-to-a-timestamp/m-p/1745890#M453309 <P>Thank you very much <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/56648">@Taoufiq_Zarra</a> !!! helped me a lot</P> Tue, 22 Sep 2020 08:49:09 GMT https://community.qlik.com/t5/QlikView/Add-2-hours-to-a-timestamp/m-p/1745890#M453309 jisephcirspy 2020-09-22T08:49:09Z