Extract(Weekday FROM "date") not working in Libreoffice Base, Firebird embbeded

Hi, I can’t get return in a query with the extrac() function in LibreOffice Base, Firebird Embedded database.

SELECT
EXTRACT( WEEKDAY FROM “Date” ) “DayOfWeek”,
EXTRACT( DAY FROM “Date” ) “Day”,
EXTRACT( MONTH FROM “Date” ) “Month”
FROM
“Tbl_Schedule”

This function returned error:
EXTRACT( WEEKDAY FROM “Date” )

However, DAY and MONTH returned correct answers.

I am currently using
Version: 6.1.6.3 (x64)

Can anyone help? What are the alternatives?

Thanks

Hello,

The problem is because of HSQLDB. Yes, your question deals with Firebird embedded.

Queries are parsed (examined) based upon HSQLDB v1.8 embedded databases. This database has no WEEKDAY function and therefore will generate a syntax error. By turning on Run SQL command directly the parsing will be bypassed and the function works.

Thank you for the answer.

@esphi,

As you have been helped, please help others to know the question has been answered by clicking on the :heavy_check_mark: in upper left area of answer which satisfied the question.

Dear @Ratslinger ,

Thank you for pointing out the difference(s). And on the 2nd paragraph, there is a supporting sentence, ‘In a future version support for embedded HSQLdb data will be retired.