convert date and time to timestamp

Davood · December 2, 2023, 3:38pm

Hi
I want to convert date and time to timestamp (Example 2023-08-17T06:00:02).
I try this by “date and time difference” node, but the result is negative timestamp(: -1692252002).

Please help me

Davood · December 2, 2023, 3:47pm

Also I in “date and time difference” node, I set fixed date and time 1970-01-01 00:00:00

rfeigel · December 2, 2023, 4:35pm

You’ve got the calculation backwards. Try this:

Davood · December 2, 2023, 5:06pm

Thanks.
It works Correctly.
But what I do when do this for a column of date and time in dataset.

rfeigel · December 3, 2023, 1:00am

There are problably many ways of doing this, but this seems to work fine.

mlauber71 · December 3, 2023, 6:18am

@Davood if you want to explore more options about date and time I can recommend this article:

system · March 2, 2024, 6:18am

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.