Monday, May 20, 2019

Search: Convert Posting Period to a Date

To convert posting period to a Date, use the below Formula (Date):

        to_date(ConCat('01 ', {postingperiod}), '')

The formula converts the period to a date through the use of CONCAT and TO_DATE functions.

In Oracle/PLSQL, the CONCAT function allows you to concatenate two strings together.

The syntax for the CONCAT function is: 

        CONCAT( string1, string2 )

            - string1 is the first string to concatenate.

            - string2 is the second string to concatenate.

Say period is equal to November in the give example, ConCat('01 ', {postingperiod}) will return '01 Nov 2013'.

We use the TO_DATE () function to convert the string '01 Nov 2013'  to a Date format.

No comments:

Post a Comment