Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TO_CHAR(pDate, 'Mon dd, yyyy', 'NLS_DATE_LANGUAGE = American') FROM DUAL;
- SELECT TO_CHAR(pDate, 'Mon dd, yyyy', 'NLS_DATE_LANGUAGE = English') FROM DUAL;
- CREATE FUNCTION to_char_abbr_month(
- in_date DATE,
- in_nls VARCHAR2
- ) RETURN VARCHAR2 DETERMINISTIC
- IS
- BEGIN
- RETURN REGEXP_REPLACE(
- TRIM( TO_CHAR( in_date, 'Month', in_nls ) ),
- '(w{3})w{2,}',
- '1.'
- )
- || ' ' || TO_CHAR( in_date, 'dd, yyyy', in_nls );
- END;
- /
- SELECT to_char_abbr_month(
- DATE '2016-01-01',
- 'NLS_DATE_LANGUAGE = American'
- )
- FROM DUAL
- Jan. 01, 2016
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement