convert date and time to timestamp

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

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

You’ve got the calculation backwards. Try this:


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

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

1 Like

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

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