To change this behaviour, you can set the date format for your current session:
alter session set NLS_DATE_FORMAT='DD-Mon-YYYY HH24:MI:SS'Now, when you view tables or resultsets, you'll have a more precise view of the data:
04-Sep-2008 09:07:51
alter session set NLS_DATE_FORMAT='DD-Mon-YYYY HH24:MI:SS'Now, when you view tables or resultsets, you'll have a more precise view of the data:
04-Sep-2008 09:07:51