Hi Ocke,
----- "Ocke Janssen" <ocke.jans...@oracle.com> 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
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
