On 2012-01-26, David W Noon <dwnoon(at)ntlworld(dot)com> wrote:
>
> Try using CURRENT_TIMESTAMP instead. In fact, CURRENT_TIMESTAMP is
> more traditional SQL than now(). I don't have an ANSI standard handy,
> so I cannot be certain when now() was added, if ever; but I have been
> using CURRENT TIMESTAMP (space instead of vinculum) under DB2 for 20
> years or more.
The planner will rewrite CURRENT_TIMESTAMP to now()
:)
--
⚂⚃ 100% natural