[Solved] FireBird, Libreoffice Base DATEDIFF

[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 268 times

[RoryOF]

Also asked at
https://ask.libreoffice.org/en/question ... -datediff/

[marcosAoo]

Also asked at
https://ask.libreoffice.org/en/question ... -datediff/

in that link that you mention, there is no answer

[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

[robleyd]

An answer that addresses both parts of the question has been posted on AskLO

[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.

[marcosAoo]

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