Page 1 of 1

[DONE] Help! how to set the pattern for timestamp?

PostPosted: Tue Aug 28, 2012 9:25 am
by imichael
Hi,

at first, thanks for the great app!

i got a problem when showing the timestamp data when querying the Oracle database.
it can't show the micro-seconds(or nano-seconds? I am not sure.).
anyway, it just can show the milliseconds, i,e: 2012-06-19 12:00:00.000 +0800 (i am using the pattern: yyyy-MM-dd HH:mm:ss.SSS Z)
but in Oracle Sql developer, I can get the result as this: 12.00.00.000123000.
the last 6 digital are important information which we can not ignored.

can you tell me how to set the pattern for Timestamp to let it show?
thanks.

and, one more thing, can I export a result set as SQL insert sequences?
if not, can you consider it as a feature request?

thanks again :-)

Re: Help! how to set the pattern for timestamp?

PostPosted: Tue Aug 28, 2012 11:30 am
by Serge
Hi,

1. Unfortunatelly currently DBeaver doesn't support nanoseconds view/edit. This is because of standard Java datetime formatting limitations and lack of micro/nano secconds edit in standard UI widgets. I'll add this feature in TODO list with high priority. Probably it will be included in the next version.

2. Yes. Currently DBeaver supports 2 formats of data export: CSV and SQL inserts. SQL inserts format supported only for tables export (not for any custom resultset). Right click on the table's resultset or on table item in navigator and choose "Export data" menu.

Thanks!

Re: Help! how to set the pattern for timestamp?

PostPosted: Sun Sep 16, 2012 8:50 am
by Serge
Nanoseconds view support added. In Time pattern add "fffffffff" at the end to view nanoseconds.
Note that nanoseconds will be printed only if they are present in actual timestamp value.