Date and Time Built-In Functions

 

Built-In Function

Description

IBM i

Windows

Linux

RDML

RDMLX

Notes

CONVERTDATE

Converts format of alphanumeric date.

Y

Y

Y

Y

Y

 

CONVERTDATE_NUMERIC

Converts format of numeric date

Y

Y

Y

Y

Y

 

DATEDIFFERENCE

Calculates the difference between two dates.

Y

Y

Y

Y

Y

 

DATEDIFFERENCE_ALPHA

Calculates the difference between two alphanumeric dates

Y

Y

Y

Y

Y

 

FINDDATE

Finds date "n" days after/before a given date.

Y

Y

Y

Y

Y

 

FINDDATE_ALPHA

Finds date "n" days after/before a given alphanumeric date

Y

Y

Y

Y

Y