SubscribeIf you are stuck using Oracle’s SQL Developer like I am (Toad is $800 now!), then don’t suffer with the braindead default date format like I have until recently. There’s nothing like just seeing the date in dd-mmm-yy format when you are working with hourly or sub-hourly data all the time like I am. What were they thinking? Anyway, you can run this once in your SQL worksheet and enter and see dates with times:
alter session set NLS_DATE_FORMAT='MM/DD/YYYY HH24:MI';
June 28, 2008 at 10:40 am
A more flexible way is to apply the to_char transformation to a date datatype column, e.g.:
select to_char(datedatatypecol, ‘MM/DD/YYYY HH24:MI:SS) from tablename;
The format mask can differ quite a bit. The default format is DD-MON-YY: select sysdate from dual; produces:
SYSDATE
———
28-JUN-08
August 8, 2008 at 4:37 pm
John,
Thanks. This was driving me crazy. However, after reading your post, I reviewed the preferences, and perhaps this was added since your post, but I did find that this can now be set in the tool (version 1.5.1), under;
Preferences->Database->NLS Parameters.
Bill