Question about Oracle 10g Database Standard (ODBSEONUPP0)
When I use Oracle date functions Format, the date format is - DD-MM-YYYY, on other machines, when I use the same function, I get this date format MM-DD-YY, this is really confusing how can I change it so both machines use the same date format?
As an Oracle Developer I do not rely on default date format. You can see the default as:
SVRMGR> select * from v$NLS_PARAMETERS; PARAMETER VALUE ----------------------------------------- ------------------ NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-YY NLS_DATE_LANGUAGE AMERICAN NLS_CHARACTERSET US7ASCII NLS_SORT BINARY NLS_NCHAR_CHARACTERSET US7ASCII Hence you can set, and use a default date format, in this case DD-MON-YY.However as a developer I use the TO_DATE function when wanting to set a date.eg vd_mydate := TO_DATE('25-07-2008','dd-mm-yyyy');Or the TO_CHAR function when displaying a date in the way I want to see it.eg. SELECT TO_CHAR(my_date_col,'"The "ddspth" of "Month, yyyy') FROM dual;
Posted on Nov 05, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of.(from cars to computers, handyman, and even drones)
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Mar 11, 2015 | Cell Phones
May 22, 2011 | Nokia E5 Cell Phone
Jan 19, 2011 | Texas Instruments BA II PLUS Financial...
Jan 02, 2011 | Cell Phones
Dec 08, 2010 | Texas Instruments BA-II Plus Calculator
Jan 10, 2009 | Canon P170-DH Calculator
Jan 03, 2009 | Cell Phones
Nov 20, 2008 | Xerox WorkCentre Pro 575 Plain Paper Laser...
Nov 15, 2007 | Intuit QuickBooks Premier: Accountant...
Oct 10, 2007 | Canon P23-DHV Calculator
253 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: