Hi Alex,
On 09.12.2010 10:35, Alex Thurgood wrote:
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'
Thanks. I found the issue and it can be fixed. Look at the issue for the
case.
- oj
PS: A space can make a big difference.
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
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org