Subject | Re: [firebird-support] Converting CURRENT_TIME to VARCHAR |
---|---|
Author | W O |
Post date | 2013-08-21T16:27:20Z |
Ok, right, bad words.
Greetings.
Walter.
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]