Date format change in PRD custom report query

[ksreelatha]

Hi All,

Please help me to guide in order to change the date format in PRD query to YYYYMMDD. I have used all the functions like CONVERT and TO_CHAR but date format is not changing after importing the custom report to SuccessFactors preview instance by default it is taking the DDMMYYY format as in the system.

Kindly provide your valuable suggestion.

Regards,

Sreelatha

[Padraig]

Hi Sreelatha

To convert a TIMESTAMP column to a preferred data format have you tried the following:

select to_char (<COLUMN_ID>,'YYYYMMDD') from PA_STUDENT

So for example, to convert the LST_UPD_TSTMP column from PA_STUDENT table for user TEST29418

select to_char (LST_UPD_TSTMP,'YYYYMMDD') from PA_STUDENT where stud_id='TEST29418'

If this information helped you then please consider giving Kudos or accepting this post as solution.

Regards

Padraig