Re: Max date

[Raul A Jager W <raul@xxxxxxxxxx>]

The exp_date is defined as date, but it is not nullable. Using null for
"does not expire" will require extra test, because RPG  will bring it as
0001-01-01

On 09/21/2015 06:34 PM, Alan Campin wrote:
> Is value a date data value and is it made nullable.
>
> On Mon, Sep 21, 2015 at 3:22 PM, Raul A Jager W <raul@xxxxxxxxxx> wrote:
>
> > I need to store a date value for a "does not expire" document. I think
> > the easiest will be to insert 9999/12/31 which when compared with the
> > actual date will result Ok.
> > Is there a symbolic name for the maximum date? something like infinite
> > for numbers?
> >
> > I will like to write something like:
> > exec sql insert into table(exp_date) values(?????)
> > where ????? will be replaced by an appropriate name.
> >
> >
> >
> >
> >
> > -- Este e-mail fue enviado desde el Mail Server del diario ABC Color --
> >             -- Verificado por Anti-Virus Corporativo Symantec --
> > --
> > This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> > mailing list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.


-- Este e-mail fue enviado desde el Mail Server del diario ABC Color -- 
            -- Verificado por Anti-Virus Corporativo Symantec --