alter session set nls_date_format = ' DD-Mon-YYYY '
Statement processed.
select to_char(date'2018-01-01', 'DAY') full_name,
to_char(date'2018-01-01', 'DY') abbreviation,
to_char(date'2018-01-01', 'D') day_of_week
from dual
FULL_NAME | ABBREVIATION | DAY_OF_WEEK |
---|---|---|
MONDAY | MON | 2 |
select to_char(date'2018-01-01', 'Day') initcap,
to_char(date'2018-01-01', 'day') lower,
to_char(date'2018-01-01', 'DAY') upper
from dual
INITCAP | LOWER | UPPER |
---|---|---|
Monday | monday | MONDAY |
alter session set nls_date_language = SPANISH
Statement processed.
select to_char(date'2018-01-01', 'Day') dy
from dual
DY |
---|
Lunes |
alter session set nls_date_language = ENGLISH
Statement processed.
select to_char(date'2018-01-01', 'Day') dy
from dual
DY |
---|
Monday |
select to_char(date'2018-01-01', 'fmDay', 'NLS_DATE_LANGUAGE = SPANISH') day_name
from dual
DAY_NAME |
---|
Lunes |
select to_char(date'2018-01-01', 'Day', 'NLS_DATE_LANGUAGE = CROATIAN') day_name,
length(to_char(date'2018-01-01', 'Day', 'NLS_DATE_LANGUAGE = CROATIAN')) monday_length,
length(to_char(date'2018-01-02', 'Day', 'NLS_DATE_LANGUAGE = CROATIAN')) padded_tuesday_length,
length(to_char(date'2018-01-02', 'FMDay', 'NLS_DATE_LANGUAGE = CROATIAN')) unpadded_tues_length
from dual
DAY_NAME | MONDAY_LENGTH | PADDED_TUESDAY_LENGTH | UNPADDED_TUES_LENGTH |
---|---|---|---|
Ponedjeljak | 11 | 11 | 6 |
alter session set nls_territory = AMERICA
Statement processed.
select to_char(date'2018-01-01', 'd') day_number
from dual
DAY_NUMBER |
---|
2 |
alter session set nls_territory = "UNITED KINGDOM"
Statement processed.
select to_char(date'2018-01-01', 'd') day_number
from dual
DAY_NUMBER |
---|
1 |