[DONE] Oracle DATE format question

Note: please leave bug reports and feature requests on

[DONE] Oracle DATE format question

Postby wsc0918 » Mon Aug 13, 2012 2:44 am

Dears:
I has setup date format as 'yyyy-MM-dd kk:mm:ss' in File-> Preferences-> Common-> Data Formats, and then I use grid view content to check data,
it always show as follow '2012-08-13 24:00:00'.
Does something wrong about my setting?
Thanks for your effort.

My environment as follow:
dbeaver version 1.6.2
Oracle 9i
WinXP 32 bit
jdk-1.6.x
wsc0918
 
Posts: 39
Joined: Thu Jul 12, 2012 12:59 pm

Re: Oracle DATE format question

Postby codebling » Mon Aug 13, 2012 7:46 pm

codebling
 
Posts: 79
Joined: Tue May 22, 2012 4:15 pm

Re: Oracle DATE format question

Postby wsc0918 » Tue Aug 14, 2012 3:00 am

you got it.
I use Oracle SQL Developer(3.0.04) and the date column value is '2012-08-10 09:44:25'.
But in dbeaver the value is '2012-08-10 24:00:00'.
wsc0918
 
Posts: 39
Joined: Thu Jul 12, 2012 12:59 pm

Re: Oracle DATE format question

Postby fallingdown » Tue Aug 14, 2012 1:08 pm

I use the format string yyyy-MM-dd HH:mm:ss and it works as I believe you want, with the 24 hour time.
fallingdown
 
Posts: 41
Joined: Fri Aug 10, 2012 2:43 pm

Re: Oracle DATE format question

Postby codebling » Tue Aug 14, 2012 3:58 pm

HH is 0 to 23, kk is 1 to 24

That's weird. I'll take a look
codebling
 
Posts: 79
Joined: Tue May 22, 2012 4:15 pm

Re: Oracle DATE format question

Postby wsc0918 » Wed Aug 15, 2012 1:21 am

I found something, in SQL editor and query data result as attachment sql_editor.png
sql_editor.png
sql_editor.png (1.66 KiB) Viewed 41264 times
.
But in grid editor is as attachment grid_editor.png
grid_editor.png
grid_editor.png (2.08 KiB) Viewed 41264 times
.
I hope this information is useful for tracing~
wsc0918
 
Posts: 39
Joined: Thu Jul 12, 2012 12:59 pm

Re: Oracle DATE format question

Postby fallingdown » Mon Aug 20, 2012 12:29 pm

I just noticed that DATE types are not showing the time portion. I was using DBeaver 1.6.1 and it seemed to work correctly then. I had the format for DATE set to yyyy-MM-dd HH:mm:ss.

I upgraded to 1.6.2 recently, and now the same format string always shows 00:00:00 for the time.
fallingdown
 
Posts: 41
Joined: Fri Aug 10, 2012 2:43 pm

Re: Oracle DATE format question

Postby Serge » Tue Aug 21, 2012 8:00 am

It seems to be a bug in DBeaver. Will be fixed in next version.

Thanks for report!
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Support



Who is online

Users browsing this forum: No registered users and 22 guests