On Wed, 21 Aug 2013 12:13:14 -0400, W O
<sistemas2000profesional@...>
wrote:

> As others had said, the context variable CURRENT_TIME returns 13
> characters.
>
> It works fine:
>
> SELECT CAST(CURRENT_TIME AS VARCHAR(13)) FROM RDB$DATABASE

CURRENT_TIME doesn't return 13 characters, but a TIME value, when cast to
(VAR)CHAR requires 13 characters, as its format is HH:mm:ss.ffff (where
ffff are fractional seconds).

Mark