On Wed, 21 Aug 2013 12:13:14 -0400, W O <[email protected]> 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
