1

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: enter image description here

In PL/SQL:

enter image description here

This is the details of the date field:

enter image description here

Jon Heller
  • 34,999
  • 6
  • 74
  • 132
Oh Chin Boon
  • 23,028
  • 51
  • 143
  • 215

3 Answers3

5

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.

Codo
  • 75,595
  • 17
  • 168
  • 206
1

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;

Mr.T
  • 33
  • 6
0

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

 select sysdate from dual
Randy
  • 16,480
  • 1
  • 37
  • 55