Wednesday, July 7, 2010

Date format in Oracle SQL Developer

I know, i know... Oracle SQL Developer really sucks :) I think i got used to it, though...
Anyway, here is the line to set custom, detailed date format for a session:
alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS';
Uff, it took me quite a while to figure it out.

No comments:

Post a Comment