Re: Valid dates allowed by the operating system

[Rob Berendt <rob@xxxxxxxxx>]

Have you tried "real" date fields?
> CREATE TABLE QTEMP/PAUL (MYDATE DATE NOT NULL WITH DEFAULT) 
  Table PAUL created in QTEMP. 
> INSERT INTO QTEMP/PAUL (MYDATE) VALUES(date('2096-12-31')) WITH NC
  1 rows inserted in PAUL in QTEMP. 
> SELECT * FROM qtemp/paul 
  SELECT statement run complete. 
MYDATE 
2096-12-31

However, you must also ensure this is set correctly:
STRSQL
F13=Services
1. Change session attributes
Date format  . . . . . . . . .   *ISO

With SQL embedded into RPG you would use 
set option datfmt = *iso
 


Rob Berendt