https://bugs.documentfoundation.org/show_bug.cgi?id=104986
Bug ID: 104986
Summary: Firebird: Function EXTRACT doesn't work with WEEKDAY,
YEARDAY, MILLISECOND
Product: LibreOffice
Version: 5.4.0.0.alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 130013
--> https://bugs.documentfoundation.org/attachment.cgi?id=130013&action=edit
Open the query "Extract" and follow the bug-description
Firebird offers the function EXTRACT to get the day of the week, as HSQLDB
offers this with its own function DAYOFWEEK.
Also the day of the year you could only get with Firebird-function EXTRACT.
HSQLDB offers this with DAYOFYEAR.
Open the attached database.
Open the query "Extract" for editing (direct SQL)
Start the query.
There is shown the week of a timestamp in last column. Note: It could only be
shown in direct SQL, while (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND) work in
GUI, too.
Now set for
EXTRACT(WEEK FROM "StartTimestamp")
EXTRACT(WEEKDAY FROM "StartTimestamp")
EXTRACT(YEARDAY FROM "StartTimestamp")
EXTRACT(MILLISECOND FROM "StartTimestamp")
Last 3 commands end with
*Token unknown - line 1, column 41
*"WEEKDAY"
...
So there is no possibility to get the WEEKDAY (and also the YEARDAY,
MILLISECOND) from the internal Firebird-database.
Tested all with
Version: 5.4.0.0.alpha0+
Build ID: 2a4cd80abcf9e515d1ce3b3a944b573bdc42bff2
CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: kde4;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2016-12-22_00:18:04
Locale: de-DE (de_DE.UTF-8); Calc: group
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
