User's Manual

Presenting Data following User's Locale Convention
8-6 Oracle Database Express Edition 2 Day Plus PHP Developer Guide Beta Draft
Oracle Date Formats
There are three different date presentation formats in Oracle Database Express Edition,
they are standard, short, and long dates. The examples below, illustrate the differences
between the short data and long date formats for both United States and Germany.
SQL> alter session set nls_territory=america nls_language=american;
Session altered.
SQL> select employee_id EmpID,
2 substr(first_name,1,1)||'.'||last_name "EmpName",
3 to_char(hire_date,'DS') "Hiredate",
4 to_char(hire_date,'DL') "Long HireDate"
5 from employees
6* where employee_id <105;
EMPID EmpName Hiredate Long HireDate
---------- --------------------------- ---------- -----------------------------
100 S.King 06/17/1987 Wednesday, June 17, 1987
101 N.Kochhar 09/21/1989 Thursday, September 21, 1989
102 L.De Haan 01/13/1993 Wednesday, January 13, 1993
103 A.Hunold 01/03/1990 Wednesday, January 3, 1990
104 B.Ernst 05/21/1991 Tuesday, May 21, 1991
SQL> alter session set nls_territory=germany nls_language=german;
Session altered.
SQL> select employee_id EmpID,
2 substr(first_name,1,1)||'.'||last_name "EmpName",
3 to_char(hire_date,'DS') "Hiredate",
4 to_char(hire_date,'DL') "Long HireDate"
5 from employees
6* where employee_id <105;
EMPID EmpName Hiredate Long HireDate
---------- --------------------------- -------- ------------------------------
100 S.King 17.06.87 Mittwoch, 17. Juni 1987
101 N.Kochhar 21.09.89 Donnerstag, 21. September 1989
102 L.De Haan 13.01.93 Mittwoch, 13. Januar 1993
103 A.Hunold 03.01.90 Mittwoch, 3. Januar 1990
104 B.Ernst 21.05.91 Dienstag, 21. Mai 1991
Oracle Number Formats
The examples below, illustrate the differences in the decimal character and group
separator between United States and Germany.
SQL> alter session set nls_territory=america;
Session altered.
SQL> select employee_id EmpID,
2 substr(first_name,1,1)||'.'||last_name "EmpName",
3 to_char(salary, '99G999D99') "Salary"
4 from employees
5* where employee_id <105