Subject | RE: [firebird-support] Re: UDF weekofyear |
---|---|
Author | Thomas Steinmaurer |
Post date | 2004-01-12T12:53:55Z |
Hi Arno,
select cast('1' as SMALLINT) from rdb$database
As you will see, it works.
Perhaps ordlog.MUTTIMESTAMP allows NULLs?
Thomas
> Thank you for your reply.Try:
> According to the Embedded SQL Guide page 125 CAST() can be used
> to 'convert' NUMERIC to CHARACTER only, not vice versa. Testing
> confirms this, CAST(R_DATETOSTR(ordlog.MUTTIMESTAMP, '%W') AS
> SMALLINT) returns nothing.
>
> I hope someone else can help me.
select cast('1' as SMALLINT) from rdb$database
As you will see, it works.
Perhaps ordlog.MUTTIMESTAMP allows NULLs?
Thomas