https://bugs.documentfoundation.org/show_bug.cgi?id=165819
Bug ID: 165819
Summary: FIREBIRD: Timestamp will be shown with 9 Decimal
Places (Tools → SQL), but could only convert 4 Decimal
Places from string
Product: LibreOffice
Version: 25.2.1.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 199899
--> https://bugs.documentfoundation.org/attachment.cgi?id=199899&action=edit
Open the database and follow the instaructions in bug description.
Open the attached database.
Execute in Tools → SQL: SELECT * FROM "tbl_Time"
Timestamps will be shown with 9 decimal places.
Now start the queries.
Query qry_Timestamp_9Decimalseconds wont work:
*conversion error from string "2025-03-19 12:22:00.000000000"
If I cut the timestamp to 4 decimalplaces it will work.
I have tried to select data from old database and insert it to new database by
selecting all as strings. Works well per macro up to the first timestamp,
because Firebird couldn't convert it's own format.
--
You are receiving this mail because:
You are the assignee for the bug.
