hi, trying to create an sql statment

insert a user_id, todays date, and a date 6 months from now, how do I add 6 monts
to a date in sql. I tryed

insert into tab_name
(user_id,
today_date,
six_month_date)
values
(12345,
today,
6 month units + today) or the other way around does not work

has anybody tryed doing something like that

Hi,

I not remember good, but please test following:

insert into tab_name
(user_id,
today_date,
six_month_date)
values
(12345,
(today + 6 units month))

Gustavo.

The expression below would work too.

today + interval(6) month to month

Tryed it, could not get it to work

Tryed it, could not get it to work, still getting a -201 syntax error

Hi,

Here are demo sql statements to do it:

create temp table tab_name (user_id char(5),today_date date, six_month_date date) with no log;

insert into tab_name select 12345, today, today+interval(6) month to month from systables where tabid=1;
insert into tab_name select 12345, today, today+6 units month from systables where tabid=1;

select * from tab_name;

Regards,
Shriyan