Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

use Perl Log In

Log In

[ Create a new account ]

jdavidb (1361)

jdavidb
  (email not shown publicly)
http://voiceofjohn.blogspot.com/

J. David Blackstone has a Bachelor of Science in Computer Science and Engineering and nine years of experience at a wireless telecommunications company, where he learned Perl and never looked back. J. David has an advantage in that he works really hard, he has a passion for writing good software, and he knows many of the world's best Perl programmers.

Journal of jdavidb (1361)

Wednesday December 06, 2006
08:54 AM

Oracle gem of the day: NLS_CALENDAR

[ #31826 ]

I'm not likely to ever use today's gem, but I am impressed. You can set NLS_CALENDAR in order to use other calendars, such as 'Arabic Hijrah'. Default, of course, is 'GREGORIAN'. I have no idea what other values are permissible. And I'm sure it's not possible for me to define my own calendar and use Shire dating, or my own custom calendar, or something. But still it's neat that they can handle that.

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • My first thought was that I could see this being a problem in exactly the same way as Perl's $[ [perl.org] in other words, setting this in too wide of a scope is going to break a lot of code making certain assumptions.

    Actually, that's not quite fair. I can at least see where NLS_CALENDAR would be useful. :)

    • Yeah, Oracle has a lot of settings like that, particularly involving dates. Personally, I'm really bugged by the default datemask: DD-Mmm-YYYY (25-Dec-2006). I'm in the US, using a US product, receiving a date that doesn't look like anything I see on a regular basis and which has no useful sorting properties. You can set this parameter at three levels: for the whole server (augh), for each session, and as an explicit parameter each time you set a date. Strangely enough one system I've been on forever ha

      --
      J. David works really hard, has a passion for writing good software, and knows many of the world's best Perl programmers