Re: date manip. prob with AIX & OnLine 5.05.UC6

Posted in 1997

Rudy Fernandes — Fri, 07 Nov 1997 12:21:36 GMT — source: Informix-list mailing list archive (1991-1998)

What about the old-fashioned select month(today - 1), day(today - 1) from systables where tabid = 1; On 6 Nov 1997 07:53:15 -0500, cmm@trac3000.ueci.com (Colin M McGrath) wrote: >I have an SQL script which generates yesterday's date, it's used to <snip> >select extend(today - 1, month to month), > extend(today - 1, day to day) >from systables >where tabid = 1; > <snip> Rudy Fernandes Purolator Courier, Canada Off : rfernand@purolator.com Res : rferdy@pathway.com