on 2023 Nov 02 9:07 AM
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
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
4 | |
4 | |
3 | |
3 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.