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:
Jul 15, 2013 | Microsoft SQL Server 2005 Standard Edition
Oct 01, 2009 | Intuit QuickBooks Premier: Accountant...
Jan 16, 2009 | Microsoft Office Professional 2007 Full...
Nov 21, 2008 | Microsoft Excel for PC
Sep 04, 2008 | Oracle 10g Database Standard (ODBSEONUPP0)
Feb 11, 2008 | Microsoft Office Access 2003 (077-02871)...
Nov 15, 2007 | Intuit QuickBooks Premier: Accountant...
Sep 24, 2007 | Microsoft SQL Server Standard Edition for...
251 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: