Re: Question about the 'CURRENT' function in 4gl

Darrel, Davis wrote: > > Does the 'CURRENT' function, without any parameters, match the > granularity of the table being affected? Fo instance, currently we > have datetime fields of YEAR TO MINUTE, and are capturing the time > with a plain 'CURRENT'. If I change the granularity of the field to > DATETIME YEAR TO SECOND will the CURRENT insert the second? > > This is on an Informix 5.x db. Darrel, as I recall, you had to explicitly specify: variable = CURRENT YEAR TO SECOND. This may have changed in 7.20 of 4GL but I doubt it. -- -- Jake (Retrospectively realizes there is no future in hindsight) +------------------------------------------------------------+ | The expedient performance of a task with excessive concern | | regarding its duration-to-completion engenders a virtual | | certainty of diminished benefit therefrom. | | -- Benjamin Franklin (but he said it in 3 words) | +------------------------------------------------------------+