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) |
+------------------------------------------------------------+