Sorry, but actual I cannot reproduce this error.
I will try to inspect this on tomorrow. Could be that the mistake is on
my side.

Thanks for replying.
Thomas


rrokytskyy wrote:

>Hi,
>
>I tried the following procedure
>
>create procedure test_date returns (date_result date)
>as begin
> date_result = cast('now' as date);
> suspend;
>end
>
>Then I tried following SQL statement using the last version of our
>driver:
>
>select cast(date_result as varchar(20)) from test_date
>
>and I do get correct output. Can you create a small test case that
>reproduces your problem?
>
>Best regards,
>Roman
>
>--- In Firebird-Java@y..., Thomas Viohl <t.viohl@o...> wrote:
>
>
>>Ok, Helen,
>>your advices are all ok. I simplified my procedure for this
>>
>>
>newsgroup ...
>
>
>>But: this does not solve my problem !!
>>
>>If I user the CAST function on the dates I get no result in that
>>
>>
>columns.
>
>
>>When I do not use CAST , firebird is implicitely casting the dates
>>
>>
>and I
>
>
>>get correct values in the resulting Varchars.
>>
>>Sample:
>>select CAST (myDate as varchar(20)) -->> no returning values
>>select myDate -->> correct values
>>
>>regards
>>Thomas
>>
>>
>
>
>
>
>To unsubscribe from this group, send an email to:
>Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>

--
Thomas Viohl
oraise GmbH
Am Wall 149/150
D-28195 Bremen (Germany)
------------------------
eMail: t.viohl@...
Fon:++49+421-335533
Fax:++49+421-3355355
------------------------