SYSDATE
---------
01-DEC-21
EMPL_LAST_NAME HIREDATE
--------------- ---------
King 17-NOV-11
Jones 02-APR-12
Blake 01-MAY-13
Raimi 09-JUN-12
Ford 03-DEC-12
Smith 17-DEC-12
Michaels 20-FEB-18
Ward 22-FEB-19
Martin 28-SEP-18
Scott 09-NOV-18
Turner 08-SEP-19
EMPL_LAST_NAME HIREDATE
--------------- ---------
Adams 23-SEP-18
James 03-DEC-17
Miller 23-JAN-16
14 rows selected.
just display the name of the month of hire
EMPL_LAST_NAME MONTH HIRED
--------------- ------------------------------------
King NOVEMBER
Jones APRIL
Blake MAY
Raimi JUNE
Ford DECEMBER
Smith DECEMBER
Michaels FEBRUARY
Ward FEBRUARY
Martin SEPTEMBER
Scott NOVEMBER
Turner SEPTEMBER
EMPL_LAST_NAME MONTH HIRED
--------------- ------------------------------------
Adams SEPTEMBER
James DECEMBER
Miller JANUARY
14 rows selected.
EMPL_LAST_NAME Month Hired
--------------- ------------------------------------
King November
Jones April
Blake May
Raimi June
Ford December
Smith December
Michaels February
Ward February
Martin September
Scott November
Turner September
EMPL_LAST_NAME Month Hired
--------------- ------------------------------------
Adams September
James December
Miller January
14 rows selected.
a few more possibilities at once:
YEAR MON_YEAR NUM_VERS
---- ----------------- --------
LONG_VERSION
--------------------------------------------------------------------------------
BRIEF_VERSION
-----------------------------------
2021 Dec 2021 12-01-21
Wednesday, December 01, 2021
WED - Dec 01 - 21
TO_CHAR(SYSDATE,'DDDDDDDAY,MONYYYY-HH12HH24MISSAM')
--------------------------------------------------------------------------------
4 01 335 Wednesday, Dec 2021 - 11 23 47 42 PM
tomorrow
---------
02-DEC-21
yesterday
---------
30-NOV-21
cannot add to a date literal string
select '31-DEC-2021' + 1
*
ERROR at line 1:
ORA-01722: invalid number
TO_DATE('
---------
01-JAN-22
HIRETIME
--------
12:00 AM
12:00 AM
12:00 AM
12:00 AM
12:00 AM
12:00 AM
12:00 AM
12:00 AM
12:00 AM
12:00 AM
12:00 AM
HIRETIME
--------
12:00 AM
12:00 AM
12:00 AM
14 rows selected.
Commit complete.
inserting an employee hired on November 15th of 2021 at 2:37 pm
1 row created.
EMPL_LAST_NAME
---------------
HIRE_DATE_TIME
--------------------------------------------------------------------------------
King
November Thursday , 2011 - 12:00 AM
Jones
April Monday , 2012 - 12:00 AM
Blake
May Wednesday, 2013 - 12:00 AM
EMPL_LAST_NAME
---------------
HIRE_DATE_TIME
--------------------------------------------------------------------------------
Raimi
June Saturday , 2012 - 12:00 AM
Ford
December Monday , 2012 - 12:00 AM
Smith
December Monday , 2012 - 12:00 AM
EMPL_LAST_NAME
---------------
HIRE_DATE_TIME
--------------------------------------------------------------------------------
Michaels
February Tuesday , 2018 - 12:00 AM
Ward
February Friday , 2019 - 12:00 AM
Martin
September Friday , 2018 - 12:00 AM
EMPL_LAST_NAME
---------------
HIRE_DATE_TIME
--------------------------------------------------------------------------------
Scott
November Friday , 2018 - 12:00 AM
Turner
September Sunday , 2019 - 12:00 AM
Adams
September Sunday , 2018 - 12:00 AM
EMPL_LAST_NAME
---------------
HIRE_DATE_TIME
--------------------------------------------------------------------------------
James
December Sunday , 2017 - 12:00 AM
Miller
January Saturday , 2016 - 12:00 AM
Hughes
November Monday , 2021 - 02:37 PM
15 rows selected.
(now removing this employee... 8-) )
Rollback complete.
ADD_MONTH
---------
28-FEB-22
MONTHS_BETWEEN(SYSDATE,TO_DATE('30-JAN-2022'))
----------------------------------------------
-1.9035013
MONTHS_BETWEEN(TO_DATE('30-JAN-2022'),SYSDATE)
----------------------------------------------
1.90350134
LOOKY LOOKY
----- -----
Silly Silly
LOWER(EMPL_LAST UPPER(EMPL_LAST
--------------- ---------------
king KING
jones JONES
blake BLAKE
raimi RAIMI
ford FORD
smith SMITH
michaels MICHAELS
ward WARD
martin MARTIN
scott SCOTT
turner TURNER
LOWER(EMPL_LAST UPPER(EMPL_LAST
--------------- ---------------
adams ADAMS
james JAMES
miller MILLER
14 rows selected.
LDOTS
------------------------------------------------
........King
.......Jones
.......Blake
.......Raimi
........Ford
.......Smith
....Michaels
........Ward
......Martin
.......Scott
......Turner
LDOTS
------------------------------------------------
.......Adams
.......James
......Miller
14 rows selected.
RDOTS
------------------------------------------------
King........
Jones.......
Blake.......
Raimi.......
Ford........
Smith.......
Michaels....
Ward........
Martin......
Scott.......
Turner......
RDOTS
------------------------------------------------
Adams.......
James.......
Miller......
14 rows selected.
Hiredate
--------------------------------------------------------------------------------
Thursday - November 11
Monday - April 12
Wednesday- May 13
Saturday - June 12
Monday - December 12
Monday - December 12
Tuesday - February 18
Friday - February 19
Friday - September 18
Friday - November 18
Sunday - September 19
Hiredate
--------------------------------------------------------------------------------
Sunday - September 18
Sunday - December 17
Saturday - January 16
14 rows selected.
LEFTC RTCHO NICER
----- ----- ------------------------------
Hi Hi Wednesday, December 01, 2021
EMPL_LAST_NAME LENGTH ABBREV3 REST
--------------- ---------- ------------ ----------
King 4 Kin g
Jones 5 Jon es
Blake 5 Bla ke
Raimi 5 Rai mi
Ford 4 For d
Smith 5 Smi th
Michaels 8 Mic haels
Ward 4 War d
Martin 6 Mar tin
Scott 5 Sco tt
Turner 6 Tur ner
EMPL_LAST_NAME LENGTH ABBREV3 REST
--------------- ---------- ------------ ----------
Adams 5 Ada ms
James 5 Jam es
Miller 6 Mil ler
14 rows selected.