Timestamp: Converting Double to Date and Time

KNIME Analytics Platform
1

Hi,

i have the following problem and i hope someone can fix it :slight_smile:

I imported a a file with a timestamp (date and time) column. The imported format of the column is a string and looks like
43109,942361111

I want to convert it into a date and time format like yyyy-mm-dd HH:mm:ss

The imported format is similar to the excel format when you convert a number to a date. It starts to count with 1900-01-01 00:00:00 and after converting the number 43109,942361111 is 2018-01-09 22:37:00

I tried a lot e.g. String to Number, Number to Int and then use the date&time node but then i will loose the time.

I hope someone has an idea to fix it.

Thank you!

1 Like
2

What unit do these floating point numbers have? It’s probabyl sufficient to multiply them so that you get seconds or milliseconds since 1.1.1970 and then you can use the UNIX Timestamp to Date&Time node.

1 Like
3

What do you mean exactly? It have been imported as a string (43109,942361111)

Can you make an example? I did not get your point.

Thanks a lot!

4

These floating point number must have some unit. It’s obviously not seconds since 1970 but maybe days since it (because of the fraction). This must be document somewhere. From there you can convert it into seconds since 1970 by simple math operations.