Re: Re: CAST() no longer working with OOO 330m16
Fernand Vanrie <[email protected]> Thu, 09 Dec 2010 18:13:46 +0100
| Newsgroups | gmane.comp.openoffice.dba.devel |
|---|---|
| Message-ID | <[email protected]> |
Ocke,
sorry in my code no "space" , then i typed "cast in uppercase(CAST), no
difference......
cast(`mag_news_export`.`DATUM` as date) AS `DATUM`,
>
> On 09.12.2010 15:28, Fernand Vanrie wrote:
>> Ocke,
>>
>> It has certainly nothing to sea with the SQL version or server type. I
>> work in a company envoriment, everyone uses the same SQL server, same
>> native OO-connector. Everyone works on OO 3.2 without problems, i test
>> 3.3 and have the CAST problem:
>> cast(`mag_news_export`.`DATUM` as date) AS `DATUM` where
>> `mag_news_export`.`DATUM` has a imported data (dd/mm/yyyy)
>> hope it helps
> I already fixed the issue and better it looks like it will make it
> into 3.3 :-) The problem was the space "CAST (" doesn't work "CAST("
> -> works.
>
> - oj
>
> PS: cws is dba33m
>>
>> Fernand
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]