cancel
Showing results for 
Search instead for 
Did you mean: 

DATE CONVERSION

0 Kudos

Hi im having trouble in date conversion. I have a source field DATAB (varchar upon extraction) which is 'DD.MM.YYYY' format.

I need to convert this to 'DDMMYYYY'

but when im using to_date (it becomes YYYY.MM.DD in output) then i used to_char 'DDMMYYY' it gets NULL or error ORA 01722 invalid number. Im using BODS 4 but this code is working fine in BODS 3.

Accepted Solutions (1)

Accepted Solutions (1)

akhileshkiran
Contributor
0 Kudos

Hi

Source:

Eg: 15.12.2015


Output:


Eg: 15122015


Mapping Logic :



Code:

to_char( to_date( "COLUMN_NAME",'DD.MM.YYYY'),'DDMMYYYY')


Output:

Regards,

Akhilesh Kiran.

former_member187605
Active Contributor
0 Kudos

Or: replace_substr(Query."INPUT", '.')

Answers (0)