How to get weekday from date

I have date format like “2017-07-16 10:24:54” and timestamp like “15632725710”. How to get weekday like “Monday” from these fields?

Hi there @anguslou,

welcome to KNIME Community Forum!

For first format (“2017-07-16 10:24:54”) first use String to Date&Time node to convert it to Local Date Time format so you can then use Extract Date&Time Fields node which will give you Sunday for this date :wink:

For second format (“15632725710”), which is UNIX timestamp with extra 0 I guess, use UNIX Timestamp to Date&Time node (input column type has to be Integer or Long, not String!) to convert it again to Local Date Time format and then use same node as mentioned above.

If any problems feel free to ask.

Happy KNIMEing!

Br,
Ivan

2 Likes

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