Re: Re: CAST() no longer working with OOO 330m16
Ocke Janssen <[email protected]> Thu, 09 Dec 2010 15:31:37 +0100
| Newsgroups | gmane.comp.openoffice.dba.devel |
|---|---|
| Message-ID | <[email protected]> |
Hi Fernand,
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