Re: DATE is TODAY or is it

sinyem@pc.jaring.my wrote: > > 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. TODAY takes no parameters. It returns today's date as a type DATE. DATE() takes one parameter. It returns that parameter converted to type DATE. The parameter can be CHAR, DATETIME or INT, but must contain a valid date. Hope that helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+