Hi,
I have a table with a double column for time - 20,200,101 (which is 1 Jan 2020)
I want to conver it to date via Number to String and String to Date&Time. However, when Number to String convers the double to “2.0200101E7”
Is there another way I can conver a double column to a date column?
Thank you.
Connor
@wuyeehow - @RolandBurger suggested this approach:
You can solve this by using a Round Double node instead of Number to String. Just set the precision to 0 and choose Standard String as output format.
That works! Thank you.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.