Insert or update a DATE field

[cdlvj]

Group,

How in the world do you insert or update a DATE field, I have browsed the pdfs/http and cannot find an example anywhere.
IDS 7.2

update table set lastdate = ??????????;

Tried CURRENT, TODAY, DATE("2005/07/18").
Thanks in Advance.

 

[vpshriyan]

create temp table x (xdt date);

insert into x values (today);
select xdt from x;

update x set xdt=mdy(06,23,2004);
select xdt from x;

update x set xdt=xdt + 1;
select xdt from x;

 

[cdlvj]

update table set lastdate = "03/05/2005";

It has to be in the above format mm/dd/yyyy.

 

[vpshriyan]

Lookup and configure your date environment:

Unix: echo $DBDATE
export DBDATE=mdy4/

Windows: echo %DBDATE%
set DBDATE=mdy4/