R12AppsQueriesSQL

Wednesday, 23 March 2022

How to change date format in BI report RTF

Use the following to change the date format 


<?xdofx:to_char(to_date(substr(TO_CHECK_DATE,1,10),’YYYY-MM-DD’),’DD-Mon-YYYY’)?>

Posted by Mukesh Singh at 06:11
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Pages

  • Home

Blog Archive

  • ►  2024 (5)
    • ►  September (1)
    • ►  August (4)
  • ►  2023 (2)
    • ►  March (2)
  • ▼  2022 (11)
    • ►  June (1)
    • ▼  March (5)
      • How to create ESS Job for the BI report in Oracle ...
      • How to change date format in BI report RTF
      • Query to get basic employee details in Oracle ERP ...
      • Query to get DFF for Project Table in Fusion
      • Query-Oracle-SQL- Get All Monday for the date range
    • ►  February (2)
    • ►  January (3)
  • ►  2021 (4)
    • ►  November (1)
    • ►  July (2)
    • ►  February (1)
  • ►  2020 (9)
    • ►  September (2)
    • ►  August (4)
    • ►  April (1)
    • ►  January (2)
  • ►  2019 (5)
    • ►  October (1)
    • ►  June (3)
    • ►  March (1)
  • ►  2018 (7)
    • ►  September (6)
    • ►  March (1)
  • ►  2014 (2)
    • ►  September (2)
  • ►  2013 (3)
    • ►  May (1)
    • ►  March (1)
    • ►  January (1)
  • ►  2012 (3)
    • ►  November (3)

About Me

Mukesh Singh
View my complete profile
Simple theme. Theme images by sebastian-julian. Powered by Blogger.