This content has been marked as final. Show 2 replies
What are your NLS settings for Date Format and Timestamp format?
What are the database defaults?
Are you sure the column is a date and not a varchar2?
I think SQL Developer does an alter session with the date format. Do you have alter session privilege?
Ignore the last question, I've tested that and it makes no difference.
Edited by: Jim Smith on Nov 14, 2012 2:22 PM
Thanks, looks like it's permission, tried on a different database supposed to be the same and it works when I update the preferences or run the alter session statement. Call to my admins to get on the case
for anyone else having simular issues, help are the statements I've tried to confirm it's permissions
alter session set NLS_DATE_FORMAT = 'DD-MON-RR HH24:MI:SS'; -- Original
alter session set NLS_DATE_FORMAT = 'DD-MON-RRRR HH24:MI:SS';
Edited by: lakeuk on 14-Nov-2012 06:37