The following table lists and describes datetime functions in iWay DQS.
Datetime Function |
Description |
---|---|
datePart(srcDate, fieldName) |
This function returns the value of the field fieldName (YEAR, MONTH or DAY) of srcDate. |
dateDiff(startDate, endDate, fieldName) |
Returns the difference between endDate and startDate expressed in fieldName units. |
today() |
Returns the current date in type DAY. |
dateAdd(srcDate, srcValue, fieldName) |
Adds the specified srcValue of the type specified by fieldName (YEAR, MONTH or DAY) to the srcDate. |
iWay Software |