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 |