Re: Getting date in informix
4gl, esql/c , sql which bit?
informix always throws an error that you must be ignoring.
With American date format
select "01/31/2005"::DATE + 1 units month
from systables
where tabid = 1
1267: The result of a datetime computation is out of range.
Try startlog and check the error log.
You need to write you own function to do this.
E.g. a stored procedure..