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:
In PL/SQL:
This is the details of the date field:
You can change this in the Tools / Preferences dialog of SQL developer:
Select Database / NLS Parameters in the tree view on the left.
Then put
dd/mm/yyyy hh24:mi:ss
into the Date Format field.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
精彩评论