Re: DATE is TODAY or is it

Posted in 1996

Jonathan Leffler — 4 Oct 1996 20:58:04 -0400 — source: Informix-list mailing list archive (1991-1998)

>From: sinyem@pc.jaring.my >Date: Fri, 4 Oct 1996 22:25:58 +0800 >X-Informix-List-Id: <list.11603> > >Just out of my curiosity, what is the main difference/significant of DATE, >DATE() and TODAY. Not the DATE data type but the built-in function DATE. DATE returns a string in American data format -- Oct 04 1996 or thereabouts. DATE() converts its argument to a date value -- it should be used for converting strings, or DATETIMEs, to DATE(), but implicit conversions deal with most of the problems anyway. TODAY returns a date value for today. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>