>Sorry for this newbie question but I still haven't found
>a solution to obtain the current time.
>I want to use it for date arithmetics like
>SELECT DATE(NOW) - distr_date FROM distribution
the current date and time (date('today') will give you midnight
of current date). I think all you need is the fact that 'now' is a
string, not an Ingres name.
SQL Reference manual will have more info than you could ever want
about the DATE datatype, and functions operating on it. Dave-Bob
sez check it out.
Ingres (ASK) 7/90-6/94
>The dbmsinfo - _bintim seconds are not the finest solution
>and the result cannot be passed to _date() or date_gmt().
--My thoughts, my ideas; no one else would admit to wanting them.
(Sometimes I'm not sure *I* do.)