current-local-dateTime function

The db2-fn:current-local-dateTime function returns the current date and time in the local time zone.

Syntax

Read syntax diagramSkip visual syntax diagramdb2-fn:current-local-dateTime()

Returned value

The returned value is an xs:dateTime value that is the current date and time. The returned value does not include a time zone component.

For example, if you invoke this function on 2 December 2009 at 6:25 in Toronto (timezone -PT5H), an example of a returned value is 2009-12-02T06:25:30.864001.