Download Latest Version tpc-c-ifmx.tar.gz (392.7 kB)
Email in envelope

Get an email when there's a new version of IIUG Software Repository

Home / StoredProcedures / add_date_eom
Name Modified Size InfoDownloads / Week
Parent folder
crsp_incr_date.sql 2020-05-11 885 Bytes
0
readme.txt 2020-05-11 932 Bytes
0
Totals: 2 Items   1.8 kB 0 
From: dberg@informix.com (David Berg)
Newsgroups: comp.databases.informix
Subject: Date calculation functions
Date: 30 Oct 1996 21:49:52 GMT

Following is a stored procedure that increments/decrements a date by a
specified number of months, returning the last day of the computed month
if the [in|de]cremented date is invalid. This particular procedure deals
with a DATE variable; you can tune it to deal with a DATETIME variable
and do other magical things if you wish.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

  ___                   ___              Principal Consultant
  /  ) __      . __/    /_ ) _    _  __  Informix Software Inc. (303) 850-0210
_/__/ (_(_ (/ / (_(_  _/__) (-' ~/ '(_-  5299 DTC Blvd #740 Englewood CO 80111
dberg@informix.com                       Opinions expressed herein are my own.

Eventually all things merge into one...and a river runs through it. -N.Maclean
Source: readme.txt, updated 2020-05-11