Transform a timestamp into a date and time format

[giad]

Hi, I have a problem in transforming a timestamp in a date and time format.
I have this format:

I have used UNIX timestamp to date&time node but it does not work because I obtain:

How can I see the normal date YEAR-MONTH-DAY HOUR-MINUTE?
Thanks
Giad

[mlauber71]

Could it be that these are NANOSECONDS?

If you want more regarding Time and Date check out my collection:

A meta collection about handling data and time functions in KNIME, R and SQL...

[giad]

Ok thanks, I have tried but I have an error:

Every date is on the year 1970. This is very strange because it should be related only to 31 of march (i take these data from BigQuery, table 20210331:

Thanks
Giad

[Daniel_Weikert]

probably a sample file would help

[takbb]

@giad

The timestamps that you have are unix timestamps in microseconds (millionths of a second). So iirc, they are the number of microseconds since 1970/01/01 00:00.

Hope that helps.
Brian

[giad]

Great, it works
Thanks!

Giad