Re: Help! SQL example needed for date comparison!

Posted in 1997

Thomas J. Girsch — Thu, 18 Dec 1997 14:01:11 -0500 — source: Informix-list mailing list archive (1991-1998)

Also look into the 'EXTEND' keyword in SQL. This can take a date or datetime and convert it to the type of units you're looking for. Mirza Fateh Ud Din Ahmad wrote in message <3499016F.576260E6@cressoft.com.pk>... >In informix, while doing date manipulation, you sometimes have to use >'Unit' keyword to identify the type of manipulation.