IDATE is a SQL User Defined Function that takes iSeries dates (really just decimal and characters fields) and converts them to SQL Date Data Type.

The following link may require a free, or paid, registration to view the tip.

http://www.think400.dk/downloads.htm

[report a broken link by clicking here]