Nikitin Sergey Blog
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.
Newer Posts
Older Posts
Home
Subscribe to:
Comments (Atom)