Oracle SQL Developer - Set NLS to give you full date and time

Published on Friday, 31 January 2014

In the SQL sheet for the database, use the following SQL:

alter session set NLS_DATE_FORMAT = "dd.mm.yyyy hh24:mi:ss";