Skip to main content

Do you know how to fetch name of the Month (ex: January) in Oracle Fusion SQL?

In this blog we are going to see how to fetch the name of the Month in Words using SQL

To fetch the name of the month (ex: January) , use below sample SQL as reference

Query:
select
to_char(sysdate,'dd-mon-yyyy', 'nls_date_language = english') curr_date
from dual

Result:
CURR_DATE
30-jan-2019

Query:
select
to_char(sysdate,'dd-Mon-yyyy', 'nls_date_language = english') curr_date
from dual

Result:
CURR_DATE
30-Jan-2019

Query:
select
to_char(sysdate,'dd-MON-yyyy', 'nls_date_language = english') curr_date
from dual

Result:
CURR_DATE
30-JAN-2019

Query:
select
to_char(sysdate,'dd-Month-yyyy', 'nls_date_language = english') curr_date
from dual

Result:
CURR_DATE
30-January-2019

Query:
select
to_char(sysdate,'dd-MONTH-yyyy', 'nls_date_language = english') curr_date
from dual

Result:
CURR_DATE
30-JANUARY-2019

In case you only need month use below

Query:
select
to_char(sysdate,'Month', 'nls_date_language = english') curr_month
from dual

Result:
CURR_MONTH
January

I hope this explains how to fetch the month name in words. If you have any questions, please post it in the comments section

Comments

  1. Anand1 March 2019 at 02:06

    Can you tell how to fetch the current day?

    ReplyDelete
    Replies
    1. Hassan1 March 2019 at 21:17

      Please refer to this blog
      https://elearningever.blogspot.com/2019/02/how-to-fetch-name-of-month-ex-january.html

      Delete
  2. Anonymous6 March 2019 at 19:40

    Fetch the Month name in words in SQL

    ReplyDelete

Post a Comment

Popular posts from this blog

Do you know how to cancel the Work Relationship using HDL in Oracle Cloud HCM?

In this blog, we are going to see how to cancel the Work Relationship using HDL (HCM Data Loader) Please make sure you have taken the back up of all the necessary data before cancelling the Work Relationship To cancel the Work Relationship, we use HDL Source Key method. Use the below sample template for reference SET PURGE_FUTURE_CHANGES N METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|PersonNumber|DateStart|WorkerType|CancelWorkRelationshipFlag DELETE|WorkRelationship|FUSION|1234|WRK_1234|Legal_Employer|1234|2018/02/01|E|Y In the above template, we do not know the values of the source keys SourceSystemOwner SourceSystemId PersonId(SourceSystemId) Use below query to fetch the SourceSystemOwner Query: select source_system_owner from hrc_integration_key_map where surrogate_id = period_of_service_id   -- pass period_of_service_id corresponding to Work Relationship Use below query to fetch the SourceSy...
3 comments
Read more

Do you know how to generate output using eText Template in Oracle Cloud BI Publisher?

In this blog, we are going to see how to generate output using eText Template in Fusion BI Publisher I am going to show this using sample data. This is my sample data Click "Export" button to download the XML file. This is my XML File Open a blank Word Document and save it as type "Rich Text Format" Add a format setup which is given below <TEMPLATE TYPE> FIXED_POSITION_BASED <OUTPUT CHARACTER SET> UTF-8 <NEW RECORD CHARACTER> Carriage Return Add a Header table which is given below. For headers, give the header name within quotes ex: 'Emplid'. For headers, use the level DATA_DS which is the top level and appears only once in the XML <LEVEL> DATA_DS <POSITION> <LENGTH> <FORMAT> <PAD> <DATA> <COMMENTS> <NEW RECORD> DATA_DS Alpha ‘Emplid’ ...
20 comments
Read more

Do you know how to fetch Oracle Cloud Talent Review Meeting Score using SQL

In this session we are going to see how to fetch Oracle Cloud Talent Review Meeting Score using SQL. SQL Text: with meeting_review_tbl_vw1 as ( select hd . person_id , hm . meeting_id , max ( to_number ( to_char ( hm . meeting_date , 'yyyymmdd' ))) max_meeting_date from hrr_dashboards hd , hrr_meetings hm where 1 = 1 and hm . meeting_id = hd . meeting_id group by hd . person_id , hm . meeting_id ) , meeting_review_tbl_vw2 as ( select hd . person_id , perf . rating_description performance , pot . rating_description potential , tal . rating_description talent_score , risk . rating_description risk_of_loss , impact . rating_description impact_of_loss from hrr_dashboards hd , meeting_review_tbl_vw1 mrtv , hrt_rating_levels_vl pot , hrt_rating_levels_vl perf , hrt_rating_levels_vl tal , hrt_rating_levels_vl risk , hrt_rating_lev...
Post a Comment
Read more