Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Brian Li — — source: Informix-list mailing list archive (1991-1998)
Dear netters, I am trying to calculate the date(13 months back) by
do the following sql and informix is returning the following error.
Anyone has idea why it is so?
Thanks in advance.
Brian Li
------------------------------------------------------------
select
datetime(1996-05-31) year to day - interval(1-1) year to month
from tbsctupd
where
subsystem_id_ind = 'j' and
subfunction_code = 'date';
# ^
# 1267: The result of a datetime computation is out of range.
#
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.