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
thank you VILLEROY
thank you worked