Generate current datetime in knime

[gujodm]

Hi there,
I would like to know if it’s possible to generate the current date time by using a specific node.
Something like the MySQL NOW() Function.

Thanks in advance.
~G

[cpadilla]

Hi @gujodm,

I assume you are not wanting to do this within a database? The 2 nodes that come to mind are: Date&Time Input and the Create Date&Time Range.

The Date&Time input has a Default Value option for “Use execution time” which is stored on a flow variable that can be used later in the workflow.

The Create Date&Time Range also have an option for “Use execution date&time” start and end and use a flow variable to store the start time.

I hope this helps,

cpadilla