to_char(bdate,'fmMonth ddth, yyyy')

  
SQL>
SQL> create table emp
  2  ( empno      NUMBER(4)    constraint E_PK primary key
  3  , ename      VARCHAR2(8)
  4  , init       VARCHAR2(5)
  5  , job        VARCHAR2(8)
  6  , mgr        NUMBER(4)
  7  , bdate      DATE
  8  , sal        NUMBER(6,2)
  9  , comm       NUMBER(6,2)
 10  , deptno     NUMBER(2)    default 10
 11  ) ;

Table created.

SQL> insert into emp values(1,'Tom','N',   'TRAINER', 13,date '1965-12-17',  800 , NULL,  20);

1 row created.

SQL> insert into emp values(2,'Jack','JAM', 'Tester',6,date '1961-02-20',  1600, 300,   30);

1 row created.

SQL> insert into emp values(3,'Wil','TF' ,  'Tester',6,date '1962-02-22',  1250, 500,   30);

1 row created.

SQL> insert into emp values(4,'Jane','JM',  'Designer', 9,date '1967-04-02',  2975, NULL,  20);

1 row created.

SQL> insert into emp values(5,'Mary','P',  'Tester',6,date '1956-09-28',  1250, 1400,  30);

1 row created.

SQL> insert into emp values(6,'Black','R',   'Designer', 9,date '1963-11-01',  2850, NULL,  30);

1 row created.

SQL> insert into emp values(7,'Chris','AB',  'Designer', 9,date '1965-06-09',  2450, NULL,  10);

1 row created.

SQL> insert into emp values(8,'Smart','SCJ', 'TRAINER', 4,date '1959-11-26',  3000, NULL,  20);

1 row created.

SQL> insert into emp values(9,'Peter','CC',   'Designer',NULL,date '1952-11-17',  5000, NULL,  10);

1 row created.

SQL> insert into emp values(10,'Take','JJ', 'Tester',6,date '1968-09-28',  1500, 0,     30);

1 row created.

SQL> insert into emp values(11,'Ana','AA',  'TRAINER', 8,date '1966-12-30',  1100, NULL,  20);

1 row created.

SQL> insert into emp values(12,'Jane','R',   'Manager',   6,date '1969-12-03',  800 , NULL,  30);

1 row created.

SQL> insert into emp values(13,'Fake','MG',   'TRAINER', 4,date '1959-02-13',  3000, NULL,  20);

1 row created.

SQL> insert into emp values(14,'Mike','TJA','Manager',   7,date '1962-01-23',  1300, NULL,  10);

1 row created.

SQL>
SQL> select ename
  2  ,      to_char(bdate,'fmMonth ddth, yyyy')
  3  from   emp;
Enter...

Tom      December 17th, 1965
Jack     Februari 20th, 1961
Wil      Februari 22nd, 1962
Jane     April 2nd, 1967
Mary     September 28th, 1956
Black    November 1st, 1963
Chris    Juni 9th, 1965
Smart    November 26th, 1959
Peter    November 17th, 1952
Take     September 28th, 1968
Ana      December 30th, 1966
Jane     December 3rd, 1969
Fake     Februari 13th, 1959
Mike     Januari 23rd, 1962

14 rows selected.

SQL> drop table emp;

Table dropped.

Related examples in the same category

1.	The TO_CHAR() function converts the expression into character data.
2.	Pass variable into to_char function
3.	Use to_char function to init an text value
4.	convert a negative number into one with a trailing "minus sign,"
5.	to_char(round(sqrt(sal),2),'9999.99')
6.	to_char(sysdate, 'Day', 'nls_date_language=Dutch')
7.	to_char(sysdate,'DAY dy Dy') as day, to_char(sysdate,'MONTH mon') as month
8.	to_char(sysdate,'hh24:mi:ss') as time
9.	CONVERSION functions: Print the current date/time as a character string and modifies the format

to_char(bdate,'fmMonth ddth, yyyy') : TO_CHAR « Conversion Functions « Oracle PL / SQL

Related examples in the same category