开发者

Date query ran in PL/SQL Developer shows time, but does not show in Oracle SQL Developer

开发者 https://www.devze.com 2023-03-23 16:54 出处:网络
The same query ran in PL/SQL Developer shows time, however it does not show in Oracle SQL Developer. Is there a way to get开发者_运维问答 the time in SQL Developer?

The same query ran in PL/SQL Developer shows time, however it does not show in Oracle SQL Developer. Is there a way to get开发者_运维问答 the time in SQL Developer?

In SQL Developer:

Date query ran in PL/SQL Developer shows time, but does not show in Oracle SQL Developer

In PL/SQL:

Date query ran in PL/SQL Developer shows time, but does not show in Oracle SQL Developer

This is the details of the date field:

Date query ran in PL/SQL Developer shows time, but does not show in Oracle SQL Developer


You can change this in the Tools / Preferences dialog of SQL developer:

  1. Select Database / NLS Parameters in the tree view on the left.

  2. Then put dd/mm/yyyy hh24:mi:ss into the Date Format field.

  3. Press OK to close the dialog.


To make it simple: use to_char() function, it will work with SQL developer as well as Pl/sql.

select to_char(sysdate,'MM-DD-YYYY HH:Mi:SS') from table_name;


Can't see your query, but in oracle, it would look like this:

 select sysdate from dual
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号