Page 1 of 1

[Solved] FireBird, Libreoffice Base DATEDIFF

Posted: Sun Jun 16, 2019 3:36 pm
by marcosAoo
Good Morning,

Please, could you give me an example of DATEDIFF, in LIBREOFFICE BASE with FIREBIRD?

HOW WOULD YOU LIKE A QUESTION IN LIBREOFFICE BASE FIREBIRD to know the current age?

Attachment example file
datediff.odb
Libreoffice BASE FIREBIRD
(3.46 KiB) Downloaded 312 times

Re: FireBird, Libreoffice Base DATEDIFF

Posted: Sun Jun 16, 2019 3:37 pm
by RoryOF

Re: FireBird, Libreoffice Base DATEDIFF

Posted: Sun Jun 16, 2019 4:58 pm
by marcosAoo
in that link that you mention, there is no answer

Re: FireBird, Libreoffice Base DATEDIFF

Posted: Sun Jun 16, 2019 5:10 pm
by Villeroy
Works in direct SQL mode (menu:Edit>"Run SQL directly")

Code: Select all

SELECT "name", datediff(day from "date1" to CURRENT_DATE)AS "Days" FROM "T1"
https://www.firebirdsql.org/refdocs/lan ... ediff.html

Re: FireBird, Libreoffice Base DATEDIFF

Posted: Mon Jun 17, 2019 3:42 am
by robleyd
An answer that addresses both parts of the question has been posted on AskLO

Re: FireBird, Libreoffice Base DATEDIFF

Posted: Mon Jun 17, 2019 10:36 am
by Villeroy
If you need an alternative to embedded HSQL, external HSQL2 is the way to go. HSQL2 provides a lot more useful features and plays very well with the Base frontend. Embedded Firebird is not production ready.

Re: FireBird, Libreoffice Base DATEDIFF

Posted: Mon Jun 17, 2019 6:25 pm
by marcosAoo
Villeroy wrote:Works in direct SQL mode (menu:Edit>"Run SQL directly")

Code: Select all

SELECT "name", datediff(day from "date1" to CURRENT_DATE)AS "Days" FROM "T1"
https://www.firebirdsql.org/refdocs/lan ... ediff.html
thank you VILLEROY

thank you worked