Extract Date&Time Fields

Extract Date&Time Fields returns 1 for 12/31/23. SQL Server returns 53. How to g et 53 from KNIME or 1 from SQL?

@izaychik63 sounds like a week I assume. Maybe it is a question when your week would start. If it starts on a sunday the date might be within the first week of the new year. Or you could interpret it as an additional week in 2023 (since this is where we still are after all) - again if your week starts on sunday.

Week numbers different date systems - KNIME Forum (76641).knwf (83.1 KB)


Great information, Mark. Thank you.

1 Like

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