Add +2 hours to a timestamp

[jisephcirspy]

Hello,

I want to add 2 hours to a timestamp (I cannot change it in the database).

The timestamp looks like this 2020-09-22 06:30:02.000000 (YYYY-MM-DD hh:mm:ss.miliseconds)

[Taoufiq_Zarra · Accepted solution]

@jisephcirspy  like :

=timestamp(Date#('2020-09-22 06:30:02.000000','YYYY-MM-DD hh:mm:ss.ffffff') + 2/24)

Example : 2020-09-22 06:30:02.000000

output:

2/24-> Nbofhour/24

[jisephcirspy]

Thank you very much @Taoufiq_Zarra !!! helped me a lot