[Libreoffice-bugs] [Bug 139315] Report Builder displays date field as number when query is executed by "run sql directly"

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139315

--- Comment #10 from Robert Großkopf <robert at familiegrosskopf.de> ---
@ herman
If it is set to 
Analyze SQL → No
it doesn't analyze the type of the field also. The content of the field are
numbers - so it will be shown as numbers. '0' → '1899-12-30'.

If it is set to
Analyze SQL → Yes
it analyzes the code and detects a data. So it will show a date.

But your code works only with Analyze SQL → No.

I won't call it a bug of the Report Builder. You could change the code so it
could work with Analyze SQL → Yes (and in the query with the GUI, not 'run SQL
directly') and it works well.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201231/59c02ae2/attachment-0001.htm>