Subject Re: [firebird-support] Converting CURRENT_TIME to VARCHAR
Author W O
Ok, right, bad words.

Greetings.

Walter.



On Wed, Aug 21, 2013 at 12:20 PM, Mark Rotteveel <mark@...>wrote:

> **
>
>
> 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
>
>
>


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