Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I suggest you refer to this list of documentation that I compiled to help people like you.

In particular, please scroll down to the user guide for the HyperSQLdb (HSQLdb).

On page 202 of this guide there is a table of available formatting codes for date and time.

That should help you if you are using the default "Embedded" data base. But please note that the default embedded HSQL data base in the most recent LO is version 1.8, not the newer 2.x, which this manual is for. So some things might not work, that is, unless you split your database and so you can upgrade to HSQL 2.x. But that being said most things should work.


If this helps you, please upvote this answer by clicking the "^" symbol to the left of this question. Thanks.

I suggest you refer to this list of documentation that I compiled to help people like you.

In particular, please scroll down to the user guide for the HyperSQLdb (HSQLdb).

On page 202 of this guide there is a table of available formatting codes for date and time.

That should help you if you are using the default "Embedded" data base. But please note that the default embedded HSQL data base in the most recent LO is version 1.8, not the newer 2.x, which this manual is for. So some things might not work, that is, unless you split your database and so you can upgrade to HSQL 2.x. But that being said most things should work.work as described.


If this helps you, please upvote this answer by clicking the "^" symbol to the left of this question. Thanks.

EDIT: I tested the user-format code "MM/DD/YYYY HH:MM:SS.000" in HSQLDB 2.3 using a split database and it works to show sub-seconds. But in HSQLDB 1.8 (comes by default w/ LO 5.2.3.3) it does not work.

(BTW, I also finally found, and added a link to the 1.8 HSQLDB manual to my documentation list below.)

old: I suggest you refer to this list of documentation that I compiled to help people like you.

In particular, please scroll down to the user guide for the HyperSQLdb (HSQLdb).

On page 202 of this guide there is a table of available formatting codes for date and time.

That should help you if you are using the default "Embedded" data base. But please note that the default embedded HSQL data base in the most recent LO is version 1.8, not the newer 2.x, which this manual is for. So some things might not work, that is, unless you split your database so you can upgrade to HSQL 2.x. But that being said most things should work as described.


If this helps you, please upvote this answer by clicking the "^" symbol to the left of this question. Thanks.

EDIT: I tested the user-format code "MM/DD/YYYY HH:MM:SS.000" in HSQLDB 2.3 using a split database and it works to show sub-seconds. But in HSQLDB 1.8 (comes by default w/ LO 5.2.3.3) it does not work.

image description

(BTW, I also finally found, and added a link to the 1.8 HSQLDB manual to my documentation list below.)

old: I suggest you refer to this list of documentation that I compiled to help people like you.

In particular, please scroll down to the user guide for the HyperSQLdb (HSQLdb).

On page 202 of this guide there is a table of available formatting codes for date and time.

That should help you if you are using the default "Embedded" data base. But please note that the default embedded HSQL data base in the most recent LO is version 1.8, not the newer 2.x, which this manual is for. So some things might not work, that is, unless you split your database so you can upgrade to HSQL 2.x. But that being said most things should work as described.


If this helps you, please upvote this answer by clicking the "^" symbol to the left of this question. Thanks.