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

Note: please leave bug reports and feature requests on

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

Postby imichael » Tue Aug 28, 2012 9:25 am

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 :-)
imichael
 
Posts: 1
Joined: Tue Aug 28, 2012 9:14 am

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

Postby Serge » Tue Aug 28, 2012 11:30 am

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!
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

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

Postby Serge » Sun Sep 16, 2012 8:50 am

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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Support



Who is online

Users browsing this forum: Google [Bot] and 10 guests