Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Formatting a date to appear as APR-22

edited Mar 15, 2023 4:49AM in Assets 1 comment

Summary:

I am expecting that the period column should present itself as APR-22 for example, but it is presenting the result of 04-22

Content (required):

I have a simple query which will be used in a large much more complex query for my Assets Register. This simple query is as below:

select distinct 

      fma.asset_id,

     fma.fixed_assets_cost opening_cost,

     to_char(fma.creation_date, 'YYYY') year,

     to_char(fma.creation_date, 'MON-YY') period

from fa_mass_additions fma


I am expecting that the period column should present itself as APR-22 for example, but it is presenting the result of 04-22

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!