current-local-date function
The db2-fn:current-local-date function returns the current date in the local time zone.
Syntax
Returned value
The returned value is an xs:date value that is the current date. The returned value does not include a time zone component.
For example, if you invoke this function on 2 December, 2009 at 3:00 Greenwich Mean Time (GMT) and the local time zone is Eastern Standard Time (-PT5H), the returned value is 2009-12-01.