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

Greetings.

Walter.

On Wed, Aug 21, 2013 at 5:54 AM, Wewe <sullen_00@...> wrote:

> **
>
>
> SELECT substring(CAST(CURRENT_TIME AS VARCHAR(13)) from 1 for 8) FROM
> RDB$DATABASE
>
> ________________________________
> From: majstor <majstoru@...>
> To: firebird-support@yahoogroups.com
> Sent: Wednesday, August 21, 2013 4:32 PM
> Subject: [firebird-support] Converting CURRENT_TIME to VARCHAR
>
>
>
>
> Hello,
>
> I have an sql statement which is don't work:
>
> SELECT CAST(CURRENT_TIME AS VARCHAR(10)) FROM RDB$DATABASE
>
> maybe I'm craisy, but what is wrong???
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]