Subject Re: [ib-support] Type Casting
Author Helen Borrie
At 12:02 PM 6/03/2003 -0300, you wrote:
>hi !!
>I have a stored procedure returning a table with only one row (string
>type) and performing a select over a date type column.
>select birthdate
>from table
>into :strdate
>So, how can I cast from a date type to a string type ?

Just cast it as a varchar of sufficient length, e.g.

select cast(current_date as varchar(11)) as SomeDate
from rdb$database /* dialect 3 only */

select cast(current_timestamp as varchar(24)) as SomeDate
from rdb$database