BASE refuse TIMESTAMPDIFF syntax

users
#1

Hi.

I would like to build an SQL request that use TIMESTAMPDIFF. As i encounter
some problems of rejected syntax i try a minimal example in sql editor :

SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01')

But either with this example, the sql editor doesn't want to save the
request neither execute it.

I'm running ooo version 4.0.1.2 on linux.

Do you think it comes from a misuse ?

Regards.

Paul.

#2

polch,
  dit you try this in "native' mode (LO just send the statement)

#3

Hi Paul,

It might help us a bit more if we knew which db engine you were using ?

Alex

#4

Hi Paul,

According to this :

https://forum.openoffice.org/en/forum/viewtopic.php?p=220192

you need to run your query in SQL Direct mode.

Alex

#5

You are right, it works with direct mode enabled.

Thank you for your help.