Re: Re: CAST() no longer working with OOO 330m16

Alex Thurgood <[email protected]> Thu, 9 Dec 2010 10:35:55 +0100 (CET)

Newsgroups	gmane.comp.openoffice.dba.devel
Message-ID	<1479559003.6249921291887355347.JavaMail.root@zimbra10-e2.priv.proxad.net>

Hi Ocke,


----- "Ocke Janssen" <[email protected]> a écrit :

> > As I mentioned, CAST works for me with OOo 3.2.1. It also works for
> me in LibreOffice (just so you know 3.3 rc1, not sure which OOo_m that
> is based on).
> One more interesting thing
> when executing
> select CAST('2001-01-01' as DATE)
> works, but when executing
> select CAST('2001-01-01' as DATE) from ´testdb´.´i115436´
> an error is thrown.


You need to create an alias for the CASTed field. If you use this statement instead, it should work :

SELECT CAST('2001-01-01' as DATE) as 'MyDate' from 'testdb'.'i115436'

> 
> Could you please add some sample data to the issue?
> 

If I get a bit of time today, I'll add some sample data to the issue.


Alex